Forum Discussion
ChayceDuncan
Qrew Captain
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
------------------------------
KellyLyons
10 months agoQrew Trainee
Thank you so much!!! You are always so helpful
------------------------------
Kelly Lyons
------------------------------