"The selected columns cannot be charted" - pie chart widget problem
I am trying to make a simple pie chart on a Dashboard, and I'm running into a bizarre issue with the columns I'm trying to select.
The source for the chart is a sheet summary report (see below screenshot). It's just one row. I've highlighted the 4 different groups of metrics that I'm looking at: project status (green), funder (blue), disease focus (orange), and region (pink).
The problem is that I can successfully make a pie chart for the columns highlighted in green and blue (see two screenshots below), but not for the ones highlighted in orange and pink. And the one that I really need right now is the orange one (disease focus).
As soon as I try to select the columns for disease focus or for the regions, the error message pops up with "The selected columns cannot be charted. Please select a different set of columns."
If I try to combine disease focus with status for example, the error doesn't appear, but only the status figures appear in the chart. If I select "all columns," only the figures for status and funder appear.
I also tried to go into the sheet summary (the source of the report) and change the formulas that the counts for disease and region are based on, to make them match the structure that Status and Funder are in, but that didn't help either.
I can find a workaround for this urgent need by just using Excel or something, since it's a super simple chart, but I would really appreciate some Smartsheet expert help in fixing the issue! We will ideally need a live-updating dashboard.
Thank you in advance!!