Duration column chart for a dashboard

NeuerNutzer ✭✭
edited 11/10/23 in Formulas and Functions


I am trying to build a chart that shows me the duration of the tasks. I would like this to be a bar chart, so i can see how long each task took in comparison (these are the same tasks in different projects that take people different amount of time).

I am unable to use a report that shows the primary column and the duration column, that is auto calculated for the gantt chart. Am I missing something? Do I need another column that calculates the duration with a formular?

Thanks a lot !


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!