RYG IF Statement Help
Hello-I am working to automate a SmartSheet for my team and have a "Status" column with RYGs (Red, Yellow, Green) which are visual assists for the status of the action item. I need help; the IF statement I created won't work.
Here is what I need:
IF the "Completed" column (based on a date entry) is populated with a date, the RYG should turn green. IF the "Scheduled" column has a date, the RYG should turn yellow. Otherwise, the RYG will be Red if both the "Completed" and "Scheduled" columns are blank.
Hoping you can help-thanks so much!
Millie
Comments
-
Hi Millie,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello! Thanks so much for your response-greatly appreciated!
Here is a screenshot of my workbook with the color status examples.
The RYG is green because a completed date was entered and the RYG is yellow because a scheduled date was entered to show "action" was taken.
I need an IF statement that will make the RYG's change color automatically based on the "Scheduled" date entered (Yellow) and the "Completed' date entered (Green).
Best, Millie
-
Try this one. Does it work?
=IF(AND(ISBLANK(Scheduled@row), ISBLANK(Completed@row)), "Red", IF(ISBLANK(Completed@row), "Yellow", "Green"))
-
YES!! YOU ROCK!! Thanks so much-the support is outstanding
-
I'm always happy to help!
Mike beat me to it!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Glad that works for you.
-
You could also work it in the opposite direction...
=IF(ISDATE(Completed@row), "Green", IF(ISDATE(Scheduled@row), "Yellow", "Red"))
Not to say that Mike is wrong. Just showing that there can be more than one solution. I find that keeping that in mind can make more complex formulas much easier when you are able to consolidate/condense/simplify.
In this particular case it doesn't make much difference though. Just a little tid-bit of info for future formula attempts.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives