RYG Ball automation based on end date and status

I am trying to automate RYG balls based on both the end date [End Date] and status [Complete]. I am using RYG balls for the [Status] column and Harvey Balls for the [Complete] column.
If [end date] is in the past and [Complete] is "full", turn rgy green
If [end date] is in the past and [Complete] is either "empty", "quarter", "half" or "three quarter", turn rgy red
If [end date] is today and [Compete] is either "empty", "quarter", "half" or "three quarter", turn rgy yellow
If [end date] is today and [Complete] is "full", turn rgy green
If [end date] is in the future and [Complete] is "full", turn rgy green
If [end date] is in the future and [Complete] is either "empty", "quarter", "half" or "three quarter", turn rgy green
Comments
-
Hi,
could you try the formula bellow :
=IF(OR(Complete@row=true,[end date]>TODAY()),"Green",IF([end date]=TODAY(),"Yellow","Red"))
Does this help?
Best Regards,
Paul.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 449 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!