Formula to change RYGG balls when Project Stage changes
Options
I am new to SS and I am trying to automate the Project Status Red, Yellow, Green & Gray balls to change to the correct color based on the Project Stage selected.
Project Stage drop down will need to work as follows:
Red Ball = Not Started
Yellow Ball = Scheduled, Field Work, Drafting, Completed, Preliminary Sent
Gray Ball = Invoiced
Green Ball = Paid
Does anyone know the correct formula to make this happen. Thanking you in advance. 3
Tags:
Comments
-
Any help in this matter will be greatly appreciated. Thanking you in advance.
-
https://www.smartsheet.com/blog/support-tip-automate-RYG-balls
the above should help.
-
I will check this out, thank you Daniel.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!