Progression chart

Hi everyone,

I have a questionnaire solution that only reports the latest attempt to answer it. It records how we as an organisation are doing against ICO Guidelines.

My manager has asked me to create a dashboard that shows progress. So a line chart that will show how the organisation is progressing.

My problem is the chart would need set up every time the questionnaire is filled in. I would have to go in and include the new data.

Would there be a way to automate that process?

The bottom 4 rows are where the data comes in. Each pair of columns would form its own line chart. It is currently set to receive a new line of data everyday. I then have to go to the dashboard and update the chart to include the new line added.

Thanks for taking a look.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!