Auto Date Population
Hello! I'm trying to have the "Date Resolved" column auto populate when the "Send Response to Requestor" is checked. This is the formula I'm using: =IF([SEND RESPONSE TO REQUSTOR] = "1", TODAY())
Here's a screen shot of my sheet:
Please help!
Thank you!
Wendy
Answers
-
Hi Wendy,
The issue with that formula is that it will update every day when you open the sheet anew, as TODAY will be a different date each day. At this time we don't have a timestamp function, please submit an Enhancement Request when you have a minute!
You could input a Date Modified system column in the sheet, although this will update the date if anything else changes in the row. Depending on what plan you're on, you could check the Activity Log to see when that column was changed, or on any plan you can right-click on the cell and check the Cell History.
If none of these alternatives will work for you, you may want to look into using Zapier to connect Smartsheet with another application that can record timestamps for you.
Thanks,
Genevieve
-
Thank you for this information, but I don't know how to use Zapier. I just tried and I don't understand it and I don't have the time to experiment. I need to be able to run reports and provide metrics measuring response time and I need to make it easier for the team (as this is functionality that will be across 22 sheets/forms) to respond.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.2K Get Help
- 386 Global Discussions
- 212 Industry Talk
- 445 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!