Put modified date into a Summary Sheet

brian25736

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...

Screenshot 2023-10-18 170613.png

Uploaded Oct 18, 202350.21 KB

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

Tim C

There is a way to do this with data shuttle, check out the solution by Prodactive Solutions. Would that work?