Does anyone Know what data is connected to this dashboard chart in the project management template.

Nick Barts

Smartsheet Help Template.docx

I have struggled figuring out what data on the sheet makes up the chart as I have tried to highlight different columns and go back through and edit the connected data source, but nothing changes. I need to understand where the Remaining and Complete % are coming from. Thanks for the help!

Paul Newcome

It is most likely coming from somewhere in the top of the sheet. Are you able to provide a screenshot of the data above your current screenshot?

Paul Newcome

It is most likely coming from somewhere in the top of the sheet. Are you able to provide a screenshot of the data above your current screenshot?

Heather_Verde

It looks like it's the Details and Working Days Remaining columns that are making up the chart.

Nick Barts

https://community.smartsheet.com/discussion/comment/336829#Comment_336829

Yes I can, here below is a screenshot of all the information above what I sent earlier. As you can see nothing is being highlighted or selected. Let me know if you need anymore information as well.

Screenshot of data.docx

Paul Newcome

Use a CTRL+F on the entire sheet to search for 56%. Try to find somewhere that it is in the same row as 44%. Double check in hidden columns and collapsed parent rows too.

In the chart itself... What columns are listed if you click on the dropdown where it says "All columns"? That may help you narrow it down as well.

Heather_Verde

All columns is the option, but if you deselect that and select the Details and Working Days Remaining columns, the same data will populate.

Paul Newcome

Ok. If you check across those two columns and find a row where 56% and 44% are on the same row then you should locate the cells being referenced for the chart.

Is there a particular reason you are trying to figure out where the source data is, or is it just out of curiosity?