RYG Automation using Drop Down lists

dcabras
dcabras
edited 12/09/19 in Formulas and Functions

Hi

I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead?

I.e. Looking at Recruitment Status:

If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and Assessments' from the drop down, I want the RYG column to show Yellow.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!