Formula in Symbols column using IF... need help!

I'm attempting my first IF formula and am needing some help. Need to produce RYG in the symbols column based on a column we use for % Complete. Keep coming up with an error. What am I doing wrong?

=IF([Complete]@row = 0), "Red", IF([Complete]@row = .01 - .99), "Yellow", IF([Complete]@row = 1), "Green")))

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @cmrapp

You have misplaced parentheses. You are closing off the IF statements too early.

Try this

=IF(Complete@row = 0, "Red", IF(Complete@row = 1, "Green", "Yellow"))

With only 3 colors you only have to define two criteria. The third color will be anything leftover that is not defined in the first two criteria.

Does this work for you?

Kelly

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.