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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!