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.