Help with nested If, Then Statement

Hi, I inherited Smartsheet templates from a staff member no longer with the organization and am trying to understand the formulas driving our metrics and dashboards.

A column formula was written to generate schedule risk as follows:

The sheet columns:

Can someone please help me understand the logic in plain speak? I want to understand the conditions for when Green, Yellow, Red or Blue symbol is generated in "Schedule Risk" column.

Thanks in advance for your help!

Ryan

Find more posts tagged with

Formulas

Accepted answers

All comments

Joe Goetschel

Looks like this is what it does.

Blue if Complete status or if it's Blank ("")

Red if the end date is in the past

Yellow if the end date is in 3 days

Otherwise it is green

I think I read that right.

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.