How to generate a report for duration (sum hours) to generate a widget.
I am trying to capture the sum of duration (hours) for multiple rows. When i generate a row report and select the column and summarize it to sum, the total displays 0. I can get it to count the number of rows with data entered.
Is there a way to generate this data to extract to a widget for a dashboard?
Tags:
Answers
-
Hi Jon,
The reason might be that the column includes letters and not pure numbers. However, you could use sheet summary instead to calculate the row and you could use that as the data source for your dashboard.
-
I have tried it as both, (example) 1h 30m and 1:30 and neither works. I will try the summary now. Thank you for the time!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 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!