How to build bar graph of submissions by user
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!