Formula to change RYGG balls when Project Stage changes

americansurveymanagement35236

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

 

americansurveymanagement35236

Any help in this matter will be greatly appreciated. Thanking you in advance.

Daniel Waddell

https://www.smartsheet.com/blog/support-tip-automate-RYG-balls

the above should help.

americansurveymanagement35236

I will check this out, thank you Daniel.