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, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 141 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!