Date Comparison Formula Help

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.

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

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!

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.