Chart not selecting data

Hello,

I am trying use a chart in a dashboard. When I try to add a chart, it prompts me to select a sheet and then a range of cells to pull data. However, once I click "OK" it will not allow me to select chart types or make any adjustments. It just doesn't show up at all as if I had not selected any information to pull from. The sheet/data I am using has text on the left and to the right is a countif formula pulling information from another sheet. It is a simple range of data much like the example video called "Smartsheet Charts" on YouTube. For example, | Other | 5 | and I would like a bar chart of 5 units and Other as the label. Of course, there are more rows of information. Can anyone help me or explain to me why it is not selecting the data?

Thank you

Find more posts tagged with

Comments

Paul Newcome

Are you able to provide some screenshots? Based on the description of your steps it should be working. I'd almost have to see what you're doing at each step to see if maybe there is something you're missing or if it's a problem with Smartsheet.

henryling

I opened up a new sheet and referenced the same exact information from the other sheet in the same format and this time it allowed me to make a chart off this table. I will mention this: on the first sheet I was trying to reference from the cells in that column are checkbox only; so I added +"" to display the count as a number in that cell. I imagine since the cells are restricted to check box only (even though the +"" will override it and display as a number) it wouldn't allow me to make a chart using that data. In any case, I used a new sheet and used the countif formula but didn't have to use +"" and it allowed me to make a chart.

Paul Newcome

Ah. The problem wasn't that the column was set to checkbox only. The + "" turns it into a text string (which allows you to override the checkbox only part), so as far as Smartsheet was concerned, there were no numbers in the first sheet to pull a chart from.

Sign in to join the conversation!

Quick Links

Trending discussions

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.