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?
Help Article Resources
Check out the Formula Handbook template!