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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!