RYG Automation using IF/AND function

SandyAbegail ✭✭
edited 12/09/19 in Smartsheet Basics


I am creating a project management sheet with RYG symbols to trcak our progress.  

I have a sheet with the projects, status and due dates. What I'm trying to achieve is for the RYG symbols to automate based on the status and deadlines.

If status is either in progress or for review, and is 2 days before the due date, should be yellow, if due date is today or more, then red, else (3 ore more days before due) should be green. 

I've been trying IF/AND functions but I can't get it right. 

Please help.