When cell from a row is marked as completed I want a second cell in same row to fill todays date
Hey all,
I'm trying to find a way to automate some metric tracking system. I've got a sheet that one of the rows has status updates and another that has completed date. When a cell is marked status for completed I want the completed date to automatically populate with the date that status is changed. Is there a formula to let this happen? I also dont want the date to change the next day, when I open the sheet up.
Thank you.
Best Answer
-
@pbaer22 Sure, use an automation workflow triggered by the status change and choose the action "record a date".
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
@pbaer22 Sure, use an automation workflow triggered by the status change and choose the action "record a date".
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
That's prefect, thank you very much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!