I would like to know if It's possible to format a field in hours and use formulas to calculate the difference between Finish and Start and to sum...
Take a look through THIS THREAD. In it there are multiple time based solutions, and there should be at least one that explains how to calculate the time difference. If you are needing help finding one that will work for you or tweaking one so that it does, feel free to let me know.
Are you able to provide a screenshot that has manually entered data to show what you are wanting to accomplish?
I'm still creating this form. Now the total activity time is input manually through form, but I want my sheet to be able to calculate this time automatically. I'll also use this input in another sheet to calculate my cycle time and make it available in a dashboard.
Thank you very much!
Happy to help. 👍️
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.