Health formula help

Hi all,

Can anyone tell me what is wrong with my formula:

=IF(Status@row = "Complete", "Green", IF(Status@row = "[On Hold]", "Gray", IF(Finish@row <> "", IF(Finish@row < TODAY(), "Red", IF(Finish@row <= TODAY(5), "Yellow", IF(Finish@row >= TODAY(1), "Green"))))))

All is working aside from the gray ball if on hold is not showing, and no error message- probably something glaringly obvious but I just cant seem to figure it out.

Many thanks,

Toni

Find more posts tagged with

Accepted answers

=Chris Palmer

Hello @Toni,

Just curious, are the brackets really necessary within "[On Hold]" ?

I'm curious if you've tried "On Hold".

Additionally, if there are different variations of "On Hold" you could try:

IF(CONTAINS("On Hold", Status@row), "Gray"

All comments

ker9

Hi @ToniC44

For the Gray, are you specifically looking for the words including the brackets: "[On Hold]"

=Chris Palmer

Hello @Toni,

Just curious, are the brackets really necessary within "[On Hold]" ?

I'm curious if you've tried "On Hold".

Additionally, if there are different variations of "On Hold" you could try:

IF(CONTAINS("On Hold", Status@row), "Gray"

ToniFK

Removed the brackets and all is working now :) Thank you!

=Chris Palmer

https://community.smartsheet.com/discussion/comment/376505#Comment_376505

Excellent! Happy this worked :-)

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.