Highlight row if date is more than 30 days old

Hi all,

I'm hoping to apply conditional formatting to highlight a row if we are more than 30 days of a date. I've tried to use formulas, but as our form responses come in they seem to skip any row that has a formula. Any ideas?

Thank you!


  • sharkasits
    sharkasits ✭✭✭✭✭

    @A.M. you need to make it a column formula so that it is on every row. Are you trying to see if something is greater than 30 days old? If so I would set up a checkbox with a column formula and then the conditional formatting based on the check box. If you provide a little more details I might be able to help more.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!