Put modified date into a Summary Sheet
I am trying to create a sheet that gets updated automatically every hour via data shuttle.
I'd like to have a summary sheet tied to it that allows me to show some values and also show the date and time the last update occurred. Summary fields don't have all the options as normal, but very simply I want to take the data from one of the cells in the Modified Date column (aut-generated by SS in the main sheet), and show that date and time...when I do a simple "=Modified1" for example it will bring in that data, but when set to Date field type in the summary sheet field, it only shows the date and not the time...
See attached for simple screen shot...is there a way to easily do this? I get an error code if I chnage the summary sheet field value to General/Text
Answers
-
There is a way to do this with data shuttle, check out the solution by Prodactive Solutions. Would that work?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!