Formula for Symbols


Hi all,

I need some help creating a formula that will auto populate a symbol field with a color based on what is listed in a different column/row which contains a status.

Blue - Complete

Green - On Track

Yellow - Not Confirmed

Red - Off Track

It would be reading off a column called "Stage".

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!