RYG Automation using IF/AND function

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
-
Thanks Paul.
Initially, I got an INVALID OPERATION error, I just have to switch the = and < signs; the correct order being <= to make the formula.
-
Happy to help!
And you are correct. Smartsheet is very particular on the order of the operators. My fingers and brain just weren't moving at the same speed apparently. Haha.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 150 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives