Looking for help with an IF statement

I am trying to create a formula to determine the schedule health if the Status does not equal "Not Started" and =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")).

I want the Schedule Health to show a Red, Yellow, or Green symbol based on the % in the Schedule Delta (%) field and if the Status field does not equal "Not Started".

The IF statement I have above will return the Red, Yellow, or Green symbol but I am having trouble modifying the formula so it will only show red, yellow, or green if the Status does not equal "Not Started".

Find more posts tagged with

Accepted answers

Paul Newcome

Try this...

=IF(Status@row <> "Not Started", IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")))

All comments

Paul Newcome

Try this...

=IF(Status@row <> "Not Started", IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")))

K Miller

Paul, I had something similar that didn't work so thank you for the help.

Paul Newcome

Happy to help. 👍️

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.