Formula for color coding more than one field
I want to color code two fields within the same table to highlight when they are past due.
Is there a way to add another due date field to this formula? If ([Medical Record/Pharmacy Review-Due D...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
IF(
[Medical Record/Pharmacy Review-Due Date] < Today(), "red",
[some other -Due Date] < Today(), "blue")
There is a great list of colours here https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000000&dr=1
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thank you Mark! Can they both be red or do they have to be different colors?
------------------------------
Nichole Stebane
------------------------------- MarkShnier__You
They can be the same color or not, it's up to you.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Your help is very much appreciated!!
------------------------------
Nichole Stebane
------------------------------
Not to complicate this any further, but how could a formula like this be adjusted to not include weekends?
------------------------------
Renee Williams
------------------------------
