Conditional formatting

Kathryn Leaney

I have two columns in my smartsheet that are dates. I would like to set a conditional formatting rule that says 'If column X is after Column Y then apply this format', is this possible?

For example 'If 'Date issued' is later than 'Date Due' apply this format' 

 

Thanks

Andrée Starå

Hi Kathryn,

Yes, but you'd have to use a so-called helper column (checkbox for example) and add a formula and then reference that in the conditional formatting rule.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting