Conditional formatting of dates

sdavis

I have two columns set up, one with a arrival date and one with a start date. I want to highlight the cells in the start date column if the proposed "start date" is before the "arrival date." The purpose if to show that the activity can't start before the materials have arrived. Does smartsheet have this ability?

Paul Newcome

Conditional formatting does not have that capability directly, but...

 

You can use a checkbox column as a helper column (I usually stick mine all the way on the right of the sheet, make the font and fill white, lock it, then hide it to keep the sheet looking clean). Simply use an IF statement that will check the box if it meets the desired criteria.

 

Then you can use conditional formatting to highlight specific (or all) columns based on whether or not the box is checked.