Issue with task health formula

Hi all,

I'm defining a column that will help PM's easily see which rows in a very large timeline to focus on (Health is the column name).

I typed this directly into SmartSheet to avoid any invisible characters. I've looked at it many times and can't see an issue with the formula. Can anyone else see it?

Based on columns named "Status", "Start Date", End Date"

Status = "Not Started", "In Progress", "Complete" NOTE: this column is a formula based on % complete

=IF(Status@row = "Complete", "🟢", IF([End Date]@row < TODAY, "🔴", IF(AND(Status@row="In Progress", [Start Date]@row < TODAY()), "🟡" , IF(AND(Status@row ="Not Started", [Start Date]@row > TODAY()), "⚪️", "⚪️"))))

Find more posts tagged with

IF(AND

Accepted answers

Nic Larsen

Looks like you're missing () after the first use of TODAY in the second section.

All comments

Nic Larsen

Looks like you're missing () after the first use of TODAY in the second section.

DianeO

That was the answer! I had only looked at it 32 times and missed that detail. Thank you @Nic Larsen !

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.