If statement based on date paired with Smartsheet Symbol

I have a sheet that lists due dates in one column, and I was wondering if there is a way to use an If/then statement within the symbol column to indicate the following:

If the due date is within last 12 months, the symbol is green

If the due date is between last 12-18 months, the symbol is yellow

If the due date is longer than last 18 months, the symbol is red

Is this possible?

Find more posts tagged with

Accepted answers

All comments

Mark Safran

Hi @Michelle Tivis

You can absolutely do this, just need to nest a few IF( ) statements and utilize the Today( ) function with a negative number argument to get your ranges. Give this a shot:

=IF(ISBLANK([Due Date]@row), "", IF([Due Date]@row >= TODAY(-365), "Green", IF([Due Date]@row >= TODAY(-548), "Yellow", "Red")))

-MCS

Michelle Tivis

Unfortunately, I'm receiving an #UNPARSEABLE error message when trying to use the above recommended formula.

Paul Newcome

@Michelle Tivis Did you update the column names to match exactly what you have in your sheet? If so, a screenshot of the formula in the sheet (similar to the screenshot below) would be helpful with troubleshooting.

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.