Dashboard Element, Count By Created, Grouped by Time (Hour)


I'm able to quickly accomplish this in Excel, but have no idea how to achieve the same in Smartsheet. We have a call log where a new Created row is automatically generated on submission. I'd like to create a graph that totals all calls by time, specifically the hour of the day.

In Excel I create a pivot on the Created column, group by Hour, then chart.

How would I accomplish this in Smartsheet?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!