SmartSheet Dashboard Not Displaying Certain Data

Nicole J

Hello,

I'm creating a dashboard that I want to display data directly from one specific source sheet. I'm trying to display data specifically from 12 unique columns, but certain selected columns are not displaying information, despite having data in that source column. Specifically, the dashboard is only displaying data from every other column.

When I try to display even the select columns that aren't working, I get the following error "The selected columns cannot be charted. Please select a different set of columns."

All of my source columns are set to the Column Type "Text/Number", and I can't find any difference in my source columns as to why every other one will not display in the dashboard.

Any advice?

Nicole J

Thanks, Paul.

By making all columns in the Source Sheet be "right aligned", that fixed it. It's now properly summing on my new sheet.

Weird, but oh well.

Mission accomplished.

Thanks, again.

Paul Newcome

Are you able to provide screenshots of the source data as well as the chart settings you are wanting to build?

Nicole J

Attached here is a screenshot of the source material (all coming from Row 1).

Sum of Children Error (Source Data).docx

Paul Newcome

How exactly is the data being populated in Row 1?

Nicole J

On the Source Sheet, all YELLOW fields are manually typed in (and the columns are all set to "Text/Number" type). All GRAY fields are function cells (Sum of Children).

All of these columns are set to "center alignment" (both horizontally and vertically) and set to "wrap".

Specifically, on the Source Sheet, Row 1 is set to "sum all children".

Paul Newcome

How are you selecting the data for the chart? What exactly are you clicking on?

Nicole J

Thanks, Paul.

By making all columns in the Source Sheet be "right aligned", that fixed it. It's now properly summing on my new sheet.

Weird, but oh well.

Mission accomplished.

Thanks, again.