Can you Change the End Date when Status Changes?
Is there a way to change the End Date to today, when a status is changed to either Completed or RYG is Green?
Answers
-
Yes, you should be able to use the Record a Date automation using either the status column (if it is a dropdown list) or the RYG. I haven't working with automations a lot with the RYG but it looks like it would work.
-
Thanks Laurie. So this looks like a great feature. Unfortunately when I tried to do this it will not work because my end date is used in the Dependency settings. Anyone know if there is another way? I need to keep the dependency settings but would still like to have the End Date entered without manual intervention.
-
@AmyBurns_BCD there is an add-on that can do this. If that's an option for your organization, I can tell you more about it.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!