How do I link RYG balls to a "status" column in another sheet?

Options

I am creating a sheet for my manager. I want to link the color of the RYG balls to the status column in my teams separate sheet. I want Yellow for the status "Received. Not started." Green for "In Progress." and "In Veeva.". Red for "On Hold" and Blue for "Completed". I've searched all over and can only find the answer for number based status. Please help.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!