Nested If formula for RYG

Good morning,

I'm having an issue with the following formula. The red and green come out, but the yellow comes back blank. Any assistance would be appreciated.

=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row <= 0.07 - 1, "Yellow", IF([% Complete]@row = 1, "Green")))

Find more posts tagged with

Formulas

Accepted answers

Laurie Bearden

I figured out the answer...I changed it to say

=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))

I tried to find a way to delete my question, but maybe this will help someone else in the future 😉

All comments

Laurie Bearden

I figured out the answer...I changed it to say

=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))

I tried to find a way to delete my question, but maybe this will help someone else in the future 😉

Genevieve P.

Thank you for posting your solution! 🙂I'm glad you were able to figure it out.

MDriggs

Thank you for leaving this up! I just used it for an issue I was stuck on and it worked for me!

Laurie

That's awesome!!! So glad I could 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.