RYG Automation using IF/AND function

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

Hi,

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. 

Comments