How to create a Line Chart to automatically include data from new rows entered in a sheet.

Mohammed Sulaiman
Mohammed Sulaiman ✭✭✭✭
edited 03/25/20 in Smartsheet Basics

I'm trying to create Line Chart widget on a Dashboard, to automatically update itself as the rows are added into the source sheet.

How this was set up:

  1. In the original data sheet, the actual and expected performance of a parent level tasks are calculated based on formulas.
  2. Every week this task is copied over to another sheet via automation, just to show the performance for a particular week. This sheet is the source sheet of the chart.
  3. A chart is then built from the data in the source sheet.

Problem:

The chart doesn't capture the data when new rows are automatically added to the sheet. How to fix this ?

Images attached for reference.





Best Answer

Answers