Forum Discussion
Try this
If(not [Confirmed Sent], "yellow")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hi Mark, so I just tried this and it worked:
If([Confirmed Sent]=false, "#ffff88")
But I have another question now. I also want to highlight/change background color to a light gray if the invoice status field equals "Reverse", "Duplicate Invoice (created in error)" or "Invoice Reversed"
Can I also do that in the report setting if I already have the above formula in there?
------------------------------
Kelly Lyons
------------------------------
- MarkShnier__You2 years ago
Qrew Legend
..... So QuickBase IF formulas are in fact much easier than Excel formulas as you can stack them vertically for readability and you can just list your conditions all in one if statement. It will evaluate the conditions in the order they are listed and take the first one which is true.
IF(
[Confirmed Sent]=false, "#ffff88",
Contains([invoice status], "reverse", "#A9A9A9"),
Contains([invoice status], "duplicate", "#A9A9A9")
You have to decide what sequence to do the testing because once it gets coloured yellow in the first line it will never have a chance to be coloured gray so you have to decide which is more important.
Laura Thacker another Quickbase developer has a nice app here with all the row colours. https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000006&dr=1 but also many of the rainbow color names work like red or pink or yellow or blue ...
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - ChayceDuncan2 years agoQrew 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
------------------------------- KellyLyons2 years agoQrew Trainee
Thank you so much!!! You are always so helpful
------------------------------
Kelly Lyons
------------------------------