If checkbox is no/false highlight row?
I am trying to highlight a row if the Checkbox field "Confirmed Sent" is false/No.
We have 2 ways to send out invoices, send now or sent via email. I have 2 fields that are checkboxes, the first is...
Forum Discussion
If([Confirmed Sent]=false or [Invoice Status]="Reverse" or [Invoice Status]="Duplicate Invoice (created in error)" or [Invoice Status]="Invoice Reversed", "#ffff88")
That combines them all to do the same color, you could do different conditions if you wanted a different color though.
If(
[Confirmed Sent]=false, "#ffff88",
[Invoice Status]="Reverse" or [Invoice Status]="Duplicate Invoice (created in error)" or [Invoice Status]="Invoice Reversed","some other color"
)
------------------------------
Chayce Duncan
------------------------------
Thank you so much!!! You are always so helpful
------------------------------
Kelly Lyons
------------------------------