Formula using the RYG status balls
I'm trying to write a formula using the RYG status balls.
These are the criteria:
Green= If the "Deployment Complete" box is checked
Yellow= if there is a date populated in "Module Go-Live Date"
Blue= for anything else (deployment is not complete and Go-Live is not scheduled)
I only got this far with the formula and (of course!) it doesn't work.
=IF([Deployment Complete],1, "Green", IF([Module Go-Live Date]@row, "", "Blue")
Thanks for your help!
Help Article Resources
Check out the Formula Handbook template!