Forum Discussion
MarkShnier__You
Qrew Legend
OK, sorry I didn't originally understand that you wanted to check for three different situation and colour code accordingly.
IF(
[Follow-Up] = "Check on Inspection","#5e9dff",
[Follow-Up] ="Waiting on email response","#aff5f1",
Today() > [Adj. By], "#FF0000")
You have to consider the sequence of the tests above because it will go with the first one that is true.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
RhondaJones
2 years agoQrew Cadet
Understood. That worked, thank you. That color page is also very helpful.
------------------------------
Rhonda Jones
------------------------------