Conditional formatting - when a date is older than....

Dan Tanner

Hi,

I'm looking for a way to highlight lines on a Smartsheet where the start date is older than three months. Is there any way to do this through Conditional formatting? I can't seem to figure it out...

Paul Newcome

You would need a helper column with a formula to flag the rows and then build your conditional formatting off of that.

Dan Tanner

Figured that would be the case, but I'm amazed it's not an option for conditional formatting. Thanks as always, Paul.

Paul Newcome

Happy to help. 👍️

CAS the CSA

This again seems like a basic function that is not available. Disappointing.