Calculating Duration between Start Date and Completed Date including the time and date
Can anyone help how would I be able to calculate the time difference/duration between Completed date (includes time and date) and submitted date (includes time and date). By the way, both in Text/Number Column Type since both column were manually provided.
I am not sure why I am getting "#INVALID OPERATION" error.
Answers
-
Hi Marie,
The only solution I've found is to set the "Submitted" and "Completed" columns as Date columns. However, the issue is that Date columns don't support timestamps. I was able to make the formula work using the "Modified Date" or "Created Date" columns, but I'm not sure if those would suit your situation. Unfortunately, despite trying several approaches, I couldn’t get the Date column to display timestamps. I hope a better solution becomes available soon.
Ask Me About Smartsheet Maps?!?!
Solving Automation, Integration, & Adoption Problems For Smartsheet Customers
Account Executive | Skyway Consulting Co
-
Thanks for the response @Hunter Taylor . I can't used Modified date since it may change when other occur in the future if ever. I do hope this would be available in the future
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!