Show added data on charts automatically

We would like to show progress of our tasks within a dashboard. To do so we automatically copy every week status information (number of task that are not started / in progress / completed / on hold) into an input sheet that acts as a log book. I would now like to visualize the progress we make in completing our tasks over time.

Unfortunately chart widgets do not show data that was added, therefore I need to manually update the link to the data that will be shown on the chart. It would be a cool feature to update this automatically.

Please vote for this, so that it can be integrated into a new release of Smart Sheet.

Thanks.

Regards

Christoph

Sign in to vote!

Find more posts tagged with

Idea Submitted

Cell linking

Comments

Genevieve P.

Hi @Christoph Hermens

When selecting source data for a chart from within a sheet, the selection stays looking at exactly the rows you manually identified, you're correct.

However! In this instance you could use a report as the source for your data. Instead of identifying specific rows, selecting a report will automatically select all rows and all data in that report, using the entirety as the source. This means that as new rows are added to the sheet, they'll automatically appear in the report (depending on your report filters), which will then automatically include them into your chart.

Let me know if that makes sense and will work for you!

Cheers,

Genevieve

Christoph Hermens

Dear Genevieve

thanks. It works and I will continue to use it.

Regards

Christoph

Quick Links

Trending ideas

Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.