IF, AND Formula for multiple parameters
Hello,
How do I create a formula for this scenario? I want the RYG Ball on the task level to automatically change colors when the dates on:
Finish is less than TODAY= Green
Finish is TODAY= Yellow
Finish is Greater than TODAY= RED
But I also want the RYG ball to turn green if the status has been marked complete, no matter what the finish date is?
Attached are the columns I am using:
Answers
-
I'd recommend a nested if/or statement over an if/and. something along the lines of:
=IF(OR(Status@row="Complete", Finish@row<TODAY()), Turn ball green, IF(Finish@row=Today(), Turn Ball Yellow, Turn Ball Red))
I haven't played with the RYG balls yet so I'm not familiar with the specific requirements to get that accomplished.
Sorry I can't give you a complete answer
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!