Graphing Data

cthrasher97141 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me.

Scenario:  Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from a dropdown list), time of day (from a dropdown list), their location (from a dropdown list), and the date (from a date picker). Each one of these elements are separate columns in a worksheet, in one row.

Solution Needed:  Provide a graph for each location on a dashboard displaying number of incident types reported by time of day, day of the month, month of the year.

This is very similar to a scatter or plot chart and I know these are not available Smartsheet but I was hoping somebody would have some ideas.

Please let me know if more info is needed, Thank you in advance!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!