Conditional Formattng for Dates in the Future



I'm trying to figure out a way to set up conditional formatting to highlight a row when 30 days have passed since the event has been scheduled.

I have set up an automation for the date to be added when our team changes the status to "Complete". I'd like to highlight the entire column blue 30 days after the scheduled date, so our team is reminded to follow up with the guest. Any ideas on how to make that work?


  • ✭✭✭✭✭

    I think it is hard to do that logic in conditional format with dates. I would add a "cheater column.."

    say "sysFollowup" and do the math to add 30 days to the completion date.

    This way you could also incorporate a check that if follow-up has been completed by say a checkmark that it disappears thus reverting the row back from blue

  • Carli Baio

    I did exactly that. Thanks so mucn!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!