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

MarkShnier__You

Qrew Legend

np,
but I can only correct the portion of the formula that was posted as i can't copy and paste code from an image.
I assume that the field [all info task] is a text field type.

IF(Trim([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

Hi Mark, All info task field is a date field.

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

MarkShnier__You
Qrew Legend
5 years ago
OK

IF(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
  Hi Mark,
  
  Thank you for your help on this. I did try that formula, but it's giving me an error due to the = in the formula. if(IsNull([all info task]) = ""
  It's an operation '=' can't be applied on types bool, text error. Our all info task field is setup as a date type. I originally tried going this route, but I also got this error.
  
  ------------------------------
  Catelyn Atkinson
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    Sorry I was too rushed multi tasking.
    
    IF(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
    ------------------------------