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

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!