Forum Discussion

Qrew Trainee

5 years ago

Color coding formula

Hi, I'm trying to color code a report depending on a couple different fields. My formula isn't working, but i'm not sure what i'm missing. Any help would be great. Field 1: [All info task] : we...

Formulas and functions

MarkShnier__You
5 years ago
OK,try this

IF(not IsNull([all info task]) or IsNull([internal due date]), "#ff66ff")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

CatelynAtkinson

Qrew Trainee

Hi Mark,

No worries, I appreciate your help. correct my logical thinking if it's wrong, but won't that show the record pink if both the fields are blank? we want to set it up to where it shows pink if a field is filled in with a date while the other one to have the record show pink if the date is not filled in.

------------------------------
Catelyn Atkinson
------------------------------

MarkShnier__You

Qrew Legend

5 years ago

OK,try this

IF(not IsNull([all info task]) or IsNull([internal due date]), "#ff66ff")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

CatelynAtkinson
Qrew Trainee
5 years ago
That's perfect! Thank you so much Mark.

------------------------------
Catelyn Atkinson
------------------------------