Health Status Formula

Hi!

Currently, I have a formula in place to indicate R,Y,G Health based on the Start/Due Date. Is it possible to add an =OR function so that if "Status" column is switched to complete the Health will indicate green.

Sorry .. very new to this.

Find more posts tagged with

Formulas

Accepted answers

ker9

You are missing the 2nd "If" in bold:

=If(Status@row="Complete", "Green", IF([Due

All comments

ker9

Adding an additional IF statement to the beginning of your formula should work.

You will also need to add an additional closing parenthesis at the end of the formula.

IF(Status@row = "Complete", "Green", + existing formula + additional )

Hope this helps!

lukas.johnson

https://community.smartsheet.com/discussion/comment/374591#Comment_374591

Thanks for your reply! Is this the way it should be written? If so I get a unparseable error. Thoughts?

ker9

You are missing the 2nd "If" in bold:

=If(Status@row="Complete", "Green", IF([Due

lukas.johnson

@ker9 There it is. Thank you so much!

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.