How do I change a row color based on another rows date?

Options

Hi guys,

I am looking to change the text color in the row labeled "Projected Start Date" to red if the date in the row "Actual Start Date" is beyond that projected start date. I assume this is something that conditional formatting can help with, but I can't seem to figure it out. Can anyone help with this?

Thanks!

Answers

  • Samuel Mueller
    Samuel Mueller Overachievers
    edited 01/20/23
    Options

    @MaddyDesautels You would need to add a helper column

    in the helper column you would have a column formula that is something like

    =if([projected start date]@row < [actual start date]@row, 1, 0)

    Then in your conditional formatting you will format the projected start date column based on if your helper column is 1.

    Does that make sense? I can send a screenshot if that helps

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!