What formula to use to change R,Y,G status?

I need a formula that will change the RYG status in the PO Status Column to yellow if the milestone complete column is unchecked on the date that is in the "End Date" column. Essentially, I want to automate the status. If the milestone is not marked complete by the end date, change the PO Status column from green to yellow.
Answers
-
You can use this formula. The formula will change the PO Status to Yellow when Milestone complete is unchecked and End Date is equal to or less than today (i.e., in the past). It will remain green otherwise.
=IF(AND([Milestone Complete]@row = 0, [End Date]@row <= TODAY()), "Yellow", "Green")
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives