RAG Ball Status Formula
I have put together a formula for RAG ball on a project Smartsheet.
=IF([Variance2]@row <= -2, "Green", IF([Variance2]@row >= -7, "Red", IF([Variance2]@row <= -6, "Yellow", IF([Variance2]@row = 0, "Blue"))
It is half working at the moment except it won't turn blue when there is a zero and for some reason isn't picking up -6 days as a yellow?
Help Article Resources
Check out the Formula Handbook template!