Red, Yellow, Green, Gray automation formula help needed for numerical ranges

I have a column called "Resource Totals" and I am trying to create conditions for the status column (Already made it a symbols column) for Red, Yellow, and Green

Green = 0.9-1.1

Yellow= 1.2-1.3

Red = >1.3

=IF([Resource Totals]@row = "0.9-1.1", "Green", IF([Resource Totals]@row = "1.2-1.3", "Yellow", IF([Resource Totals]@row > 1.3, "Red")))

No color is populating😟 for Green or Yellow but Red works just fine. Am I doing something wrong?

Supplemental Information:

My current values for my "Resource Totals" column are: 1.2, 1, 1.1, 1.3, 1.5 (only this one is red)

Find more posts tagged with

Formulas

Accepted answers

All comments

Ipshita

Hi @lovelyemy Yes, there is a small error in your formula -

Use this instead - =IF([Resource Totals]@row <= "0.9-1.1", "Green", IF([Resource Totals]@row <= "1.2-1.3", "Yellow", IF([Resource Totals]@row > 1.3, "Red")))

Hope this helps, don't forget to mark my response as "Awesome" if it does ;)

Cheers!

Ipshita

lovelyemy

Hi there, your formula works for everything except when I have any 1.3 values. Instead of it being yellow, it's just blank.

Genevieve P.

Hiya! Just jumping in here.

It looks like all you need to do is add an = sign after the > sign, like so:

IF([Resource Totals]@row >= 1.3,

Cheers,

Genevieve

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.