Date Comparison Formula Help

Tartaruchus77

I am a SmartSheet novice, but my team is used to base tracking in SmartSheet. I would like to set up conditional formatting that highlights if a site's planned schedule puts the site at risk.

I would like to compare two columns: "Construction Schedule: Turnover to Retail Date" against "Exterior Installation: Scheduled Date".

If the Construction Schedule date is less than 14 Days after the Exterior Installation date, I would like for the checkbox to become active.

I don't understand enough about the formatting of formulas to make this happen.

Monique Odom-Stearn

Hello @Tartaruchus77,

First, you'll want to create a Checkbox column that is not restricted to checkbox use only. Then, use the following formula:

=IF([Construction Schedule: Turnover to Retail Date]@row < ([Exterior Installation: Scheduled Date]@row + 14), true)

Convert it to a column formula, and then you'll be able to create a Conditional Formatting rule for when that column is checked!

Monique Odom-Stearn

Hello @Tartaruchus77,

First, you'll want to create a Checkbox column that is not restricted to checkbox use only. Then, use the following formula:

=IF([Construction Schedule: Turnover to Retail Date]@row < ([Exterior Installation: Scheduled Date]@row + 14), true)

Convert it to a column formula, and then you'll be able to create a Conditional Formatting rule for when that column is checked!