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| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives