Charts referencing cell with formula

Hi, having an issue with charts. I'm thinking there must be an easy solution that I'm missing. I am trying to create a chart in a new dashboard. When I select the data from a sheet or report, the following error comes up "Invalid Data. To create a chart you must use numeric data". The data in the cells I selected are numeric, but are generated using a formula. Is there another way I can get the chart to display without having to lose my formulas? I want the chart to accurately reflect the current totals.

Thanks!

Find more posts tagged with

Comments

Nic Larsen

Is your formula converting the number to a text? Meaning - does the formula if true or false return a number value between quotes in the formula. Is the value on the left or right of your cell. If the number is on the left, it is returning it as text. If so, you might need to use the Value() formula to pull the result in to another cell which you can use for your chart.

Jennifer E

Yes, it was converting to text. I used the Value formula you suggested and it works now. Thank you!!

Nic Larsen

Excellent. You can also potentially update your formula to remove the quotes, but if it may be more work given this is now working for you.

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.