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...

KellyLyons

Qrew Trainee

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__You

Qrew Legend

2 years ago

..... 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
------------------------------

Forum Discussion

If checkbox is no/false highlight row?