Using entire columns to create dashboards in lieu of cells

I am tryin to create a dashboard that tracks a trend over time (weeks). It is pulling from a sheet where we document production week to week. I'd like to create a dashboard that will pull from the entire columns so that when I add future data it will automatically pull into the dashboard.


So far it seems that I have to manually select the cells I want to pull data from.

Is setting column as a data source for a dashboard possible?


Answers

  • Hi @Luis Perez

    You can use a Report as a source for a Chart!

    When a Report is selected as a source, the entirety of the content is used in the Chart (you cannot select specific cells). This means that as new rows are added to the sheet they will automatically appear in the Report, which will then automatically update the Chart.

    See: Using Chart Widgets

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!