How to add a time stamp when a status is changed?
In the Sheet change there's a Record the date when specified criteria are met and is there one for Time? Or is there a formula to capture when specified criteria are met the adds a time stamp?
Answers
-
You can use the Modified Date column in your sheet. It will capture the date and time of any modification to the row. The only downside is that it will keep on updating whenever there are changes to the row
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Hi Vanessa,
I recommend trying the solution from this thread. The solution is to use a helper sheet. When the criteria is met, you'll use automation to copy the row over to another sheet, and this other sheet will have the "Modified" column which includes the date and the time.
Then you'll update your main sheet to reference the modified column from this other sheet.
Best!
SSFeatures - The browser extension that adds more features into SmartSheet.
- Automatic sorting, sorting with filters, saving sort settings
- Spell checking
- Report PDF generator that supports grouped and summarized reports
-
Hi,
I hope you're well and safe!
Please look at my post below, which contains a method I developed.More info:
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@VanessaRivera01 Take a look a this method that I developed to capture date / time stamp data as static data based on a specific action. Once the below is set up, you would use an INDEX/MATCH to pull the date / time stamp back over to your working sheet.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives