auto date entry multiple columns
i have multiple columns in a sheet for various tasks that need to be completed (water, electric, etc.). the columns are a dropdown to pick from complete, in progress, not started. i wanted to insert a column next to each task that would insert the current date & time when the status was changed to complete. i attached a mock up picture of what I'm hoping to accomplish
The auto-number functionality does not appear to work for multiple columns.
Is there a way to accomplish this?
Comments
-
Smartsheet doesn't have a timestamp function outside of Created and Last Updated. The only real solution is to either have users input it or to manually do it later looking at the cell history.
If there are NO updates to the row after the status changes to Complete, you could use the auto-lock feature to lock the row as soon as the status changes to complete in conjunction with the last modified type column.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives