Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hello,
I'm trying to select the pie chart, and it tells me that this chart type is not available. Any ideas?
Can you share a screenshot of your data? It looks like your missing data.
Check your columns. Pie Charts can only use 2 columns (Label and Number), and must have at least one label that has a number already above zero. If all amounts are zero, there is nothing to show on a Pie Chart, therefore it will not be an available option.
Did that work for you?
Not sure about the original requester, but it helped me.
Thanks!
What if I want to show a pie chart of projects by US region? i.e. we have a list of projects (column), the projects have a region (location) assigned to them (column), I want to calculate the percentage of projects for each region (total 100%). How do I do that? There is not a number value to calculate the percentage, but I should be able to take the number of projects for each region and calculate a percentage of the total number of projects.
Hi @TristanS
What I would do in this instance is create a Row Report from this sheet.
Then you can GROUP by the Region, and use the SUMMARIZE function to Count how many rows are in each Region. Once you have a Grouping and Summary row in your Report, you can use this Report as the source for your Chart. A Pie Chart will automatically create percentages out of those numbers.
Here's a webinar that goes through these features: Redesigned Reports with Grouping and Summary Functions
Cheers!
Genevieve
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
