# RAG Range Formula?

Options

Hi

I have a RAG legend which looks like this-:

0-49% = Red

50-79% = Amber

80-100% = Green

Like below

I have a formula on my sheet which calculates a percentage on a monthly basis.

I want the percentage to show in the next cell the relevant RAG e.g. 82% would be green or 55% would be amber.

What is the best functions to use for this? https://help.smartsheet.com/functions

Thanks.

Lindsay

Tags:

• Options

Hi

I have RAG legend which is like this

I want a cell to report the RAG based on the range the % is.

E.g. 55% = Amber

10% = Red

Been looking at the function list and not sure where to start, any recommendations for this?

Thanks.

Lindsay

• ✭✭✭✭✭✭
Options

What colors would you want for 50% and 80% since you have them overlapped into two different ones?

• Options

@Paul Newcome well that screen grab was an example of one someone else is in the team uses. But my RAG would be

0-49% = Red

50-79% = Amber

80-100% = Green

Lindsay

• ✭✭✭✭✭✭
Options

Ok. Next things to check would be the data types...

When you input the percentages in the main portion of the sheet are you entering a number into a text/number column that is formatted for percentages?

Same question as above except for the two columns used in your matrix?

• Options

Yes the column where the % is, is txt/number and formatted with % and likewise for the matrix for the RAG.

Lindsay

• Options

@Paul Newcome Yeah I don't really need to look at the table - it's there as a guidance on what each of the RAGs are.

But the second one worked!

Thank you - this is awesome.

Lindsay

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!