Creating an automated dashboard from Forms

Joe Song

Hi all,

I'm struggling to find a solution for creating automated line graphs that generate based on the weekly survey I send out via Smartsheet Forms. In Excel, for instance, I could easily create a pivot table from a dataset, and the chart would update automatically whenever new data is entered. Is there a way to achieve this in Smartsheet?

Thanks!

Joe

Paul Newcome

There are a number of ways to do this, but we would need to know the layout of your source data (screenshots if possible) as well as the expected chart visual.

Joe Song

This is an example of a source data. Joe Smith would be completing weekly surveys via smartsheet forms

And this is the expected chart visual

I'd like for the charts to update as the weekly surveys come in

Hopefully that makes sense!

Paul Newcome

You would create a report from the source sheet. You would only need the week # column and the column containing the #s you want to chart.