Automate RYG ball with criteria criteria pivoting around due date.
trying to figure out automation formula for the status balls based on the following...
- Done check box ticked - BLUE
- Open Tasks - GREEN
- Caution - YELLOW (week before and week after the due date)
- Overdue - RED (more than week after the Due date)
It's the yellow I am struggling with. Do I need to create an additional column to count an absolute value +/- away from the due date?
Comments
-
I'm close but I'm not getting the desired result. Something is wrong and I haven't figured it out.... There is no date I can select that returns YELLOW. It's all Reds, until I set a date 7 days in the future. Then everything is green.
=IF(Done@row = 1, "Blue", IF([Due Date]@row - 7 < TODAY(), "Red", IF([Due Date]@row + 7 > TODAY(), "Green", "Yellow")))
-
Here is a screenshot without the blue portion - showing its working.
-
That worked! Thanks for the help though this, working with the Today() seems like a much better approach. I didn't realize that you could insert your +/- days within those brackets. Awesome. Thanks again!
-
Awesome, glad I could help you out!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives