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.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!