Discussions

Expand all | Collapse all

Color coding formula

Jump to Best Answer
  • 1.  Color coding formula

    Posted 6 days ago
    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
    ------------------------------


  • 2.  RE: Color coding formula

    Posted 6 days ago
    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
    ------------------------------



  • 3.  RE: Color coding formula

    Posted 6 days ago
    Hi Mark, All info task field is a date field.

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



  • 4.  RE: Color coding formula

    Posted 6 days 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
    ------------------------------



  • 5.  RE: Color coding formula

    Posted 6 days 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
    ------------------------------



  • 6.  RE: Color coding formula

    Posted 6 days 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
    ------------------------------



  • 7.  RE: Color coding formula

    Posted 6 days ago
    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
    ------------------------------



  • 8.  RE: Color coding formula
    Best Answer

    Posted 6 days 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
    ------------------------------



  • 9.  RE: Color coding formula

    Posted 6 days ago
    That's perfect! Thank you so  much Mark.

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