How to build bar graph of submissions by user

Options
Patrick Dodd
Patrick Dodd ✭✭
edited 04/16/20 in Formulas and Functions

We are using Smartsheet to build a Change Management process for our IT department. The way it currently works is we have a form that users fill out containing all the details of their change request, which are recording to a spreadsheet. I'm building a metrics dashboard for this, and am trying to determine a way to build a graph showing the number of requests made by each requester.


On the form, one of the required fields is the name of the person submitting the request - we require them to type out the name because the person entering the data in the form isn't always the person making the request.


My current thought was to create a separate grid, link the Requester Name cells to this grid along with a tally of the requests they've submitted in a second column, and build a graph off of this.


The problem I'm running in to is new entries via the form aren't populating the Requester Name in the second spreadsheet. Does anyone know of a way to automate this so that every time a request is submitted, the Requester Name gets added to this second sheet, in turn updating the graph?


Any and all ideas are appreciated, thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!