Original Message:
Sent: 02-20-2023 15:53
From: Mark Shnier (Your Quickbase Coach)
Subject: Formula for color coding more than one field
They can be the same color or not, it's up to you.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 02-20-2023 15:52
From: Nichole Stebane
Subject: Formula for color coding more than one field
Thank you Mark! Can they both be red or do they have to be different colors?
------------------------------
Nichole Stebane
Original Message:
Sent: 02-20-2023 14:02
From: Mark Shnier (Your Quickbase Coach)
Subject: Formula for color coding more than one field
np,
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
Original Message:
Sent: 02-20-2023 12:47
From: Nichole Stebane
Subject: 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 Date] < Today(), "red", "")
Thank you!!
------------------------------
Nichole Stebane
------------------------------