Row Color Change - Based upon formula content

Options

I would like to color an entire row, based upon the result from a date formula. Is that possible? For example, if today's date field is x number of days beyond another date field, I would like to color the entire row a specific color. Thanks for your help.

Answers

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭
    Options

    Condition formatting does not allow you to using conditions between two or more cells.

    So I would suggest the use of an helper column, preferably a checkbox type. If Date A is x number of days beyond Date B, then check the box.

    =IF(DATE-A@row>(DATE-B@row+X),1,0)

    Then use conditional formatting based on the checkbox. It'll do the trick.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!