Put modified date into a Summary Sheet

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!