Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Subtracting time using formulas
Comments
-
Shawn,
=[Completion Time]-[Start Time]
See this link for more Date related functionality:
http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas#date
Hope this helps,
Craig
-
Craigs suggestion will work in some cases but not if you are trying to calculate actual time, such as 10:30am - 5:50pm.
We are working on improvements to our formula engine will include the ability to calculate time. Stay tuned for this and other great enhancements!
-
Thank you Craig and Travis for your responses.
Craig, when do you anticipate the improvement to the formula engine to be completed? -
Shawn,
Travis is the one to ask.
I eagerly await each new improvement like a child on his birthday. But I have to wait like everyone else.
I take a look at the road map every once in a while.
https://www.smartsheet.com/product-roadmap
Craig
-
I would love to see this!
-
Shawn, we dont have a set timeframe for when the new engine will be released. We are currently working on it and there is a lot of testing that needs to go into it as it will touch a lot of functionality in the app. Keep checking out product roadmap as that will give you a good idea of what is coming soon
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives