Create conditional formatting based on data

edited 03/22/24 in Formulas and Functions

I have a sheet to track data for incidents at different buildings by date.

I'm looking to have the building cell be highlighted if it has had multiple incidents in the last 30 days.

Ideally if I can do this with conditional formatting or use a check box formula that feeds into it.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!