How to get date and time via formula in the smartsheet?
Answers
-
Are you able to provide more context?
-
Yes, for example in the Smartsheet if we give TODAY Function we get only the date "09/09/2022", similarly, I am expecting a formula where I can show the date and time in the same cell. Else, is there a function where I can calculate only the total hours between two dates?
-
The only ways to capture a time are to manually enter it or have it automatically output in either a system generated Created (date) type column or a system generated Modified (date) type column.
From there you can use some of the solutions found in the below thread to calculate the amount of time in between.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!