Use of Coloured Symbols


I have two columns that use formulae to calculate whether a Task is on budget based on the hours worked over the Revised Hours.

The first column uses RYG balls whereas the second column uses RYG 3-state arrows. The first column displays the coloured symbol but the second column displays the colour as a word. I have tried using both "Yellow" and "Orange" for the Budget Flag column without success.

I can't work out what I am doing wrong and would appreciate any help that you could give!

Many thanks.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!