How to set up a RAG column which displays results as colours



I'm currently trying to create a RAG column that will auto-populate dependent on the project variance value. I would also like to display a grey dot if the column hasn't yet been populated.

Can anyone help me out with how to create this please?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!