SmartSheet Dashboard Not Displaying Certain Data

Nicole J
Nicole J ✭✭✭✭
edited 06/15/22 in Formulas and Functions


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?


Best Answer

  • Nicole J
    Nicole J ✭✭✭✭
    Answer ✓

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!