Forum Discussion

CatelynAtkinson's avatar
CatelynAtkinson
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 want the record to be pink if it has a date. 
Field 2: [internal due date] : we want the record to be pink if it doesn't have a date

Here's my formula

if(not isnull([all info task]) or [internal due date]= isnull, "#ff66ff")
)



------------------------------
Catelyn Atkinson
------------------------------
  • MarkShnier__You's avatar
    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
    ------------------------------
  • 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's avatar
      CatelynAtkinson
      Qrew Trainee
      Hi Mark, All info task field is a date field.

      ------------------------------
      Catelyn Atkinson
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------