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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives