Status Column to Flag Red Or Green - (different rows have different range)

I am having an issue and need some assistance.

I have 3 columns A, B and C

Column A- Lower range (a number)

Column B - Upper range (a number)

Column C - Status Column (Red, Amber and Green dots)

I have several rows with different upper and lower ranges

I want the status column to flag 'Red' if its above or below the ranges and 'Green' if it is within the normal range. Please note that each row may have different upper and lower ranges.

Can any one assist?

Find more posts tagged with

Accepted answers

Paul Newcome

It would be something along the lines of

=IF(AND([Column Name]@row>= [Lower Range]@row, [Column name]@row<= [Upper Range]@row), "Green", "Red")

All comments

Paul Newcome

It would be something along the lines of

=IF(AND([Column Name]@row>= [Lower Range]@row, [Column name]@row<= [Upper Range]@row), "Green", "Red")

Vinton Douglas

Many thanks. It works like a charm.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.