RYG Balls on Simple Formula

Hi...simply I want to show a red ball if my value is less than 1, green if it is greater than 5 and yellow if between? I'm missing something?

=IF([Operations Metric]1 < 1, "Red", IF([Operations Metric]1 > 5, "Green", IF([Operations Metric]1, "Yellow")))

Find more posts tagged with

Accepted answers

Paul Newcome

Try this...

=IF([Operations Metric]1 < 1, "Red", IF([Operations Metric]1 > 5, "Green", "Yellow"))

All comments

Paul Newcome

Try this...

=IF([Operations Metric]1 < 1, "Red", IF([Operations Metric]1 > 5, "Green", "Yellow"))

John Littler

Great...thx Paul, too many arguments I guess!

Paul Newcome

Happy to help. 👍️

The problem actually wasn't too many arguments. It was your last argument for "Yellow". You didn't have an actual argument. Just a cell reference.

IF([Operations Metric]1, "Yellow")

Since you already had high and low ends ends established, you can just use "Yellow" as the default for anything that doesn't fall under the previous two.

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.