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
Check out the Formula Handbook template!