Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Where is the table button?
- Open the sheet containing your data.
- Select the range of cells containing your data.
- Click on the “Table” button in the top menu bar. The button looks like a grid of cells with a thick border around it.
- Choose “Create Table” from the drop-down menu.
- In the “Create Table” dialog box, select the “My table has headers” checkbox.
- Enter a name for your table in the “Table Name” field.
- Click “Create”.
Best Answer
-
Under value labels you can choose percentage or amount. I don't think you can show both.
To include all weeks for the 1st quarter you can sum the data in the sheet and select the totals for your chart. I would do this using a SUMIFS formula.
If your data looks like this
You can create a total like this
Using the formula
=SUMIFS([Opened Complaints]:[Opened Complaints], $[QT Week]:$[QT Week], >=1, $[QT Week]:$[QT Week], <=12)
and
=SUMIFS([Closed Complaints]:[Closed Complaints], $[QT Week]:$[QT Week], >=1, $[QT Week]:$[QT Week], <=12)
where 1 and 12 are the first and last weeks in the quarter.
Use this data to create your pie chart
Answers
-
🤔 Those sound like instructions for Excel, not smartsheet. What are you trying to do?
-
I have data in a calculation sheet. I want to present it as a pie chart in a dashboard. When I attach the data to a widget pie is grayed out. Not selectable. What am I doing wrong?
-
Click on Add Widget
Click on Chart
Click on Add Data
Select your calculation sheet from the tree on the left
Highlight the data to use in your pie chart
Click OK
The chart should appear
-
Thank you very much. I've used this method. Is it the format of my data that doesn't allow me to use the pie chart.
-
Data looks fine.
You need to highlight the data you want to chart, which looks to be Opened Complains and Closed Complaints
To get
Is that what you are doing/want?
-
This is much nearer. I also need to show a number as the sum. 1=25% and 3=75% for a total number of 4 complaints and the week. The pie would need to represent all the weeks of the 1st qt.
-
Under value labels you can choose percentage or amount. I don't think you can show both.
To include all weeks for the 1st quarter you can sum the data in the sheet and select the totals for your chart. I would do this using a SUMIFS formula.
If your data looks like this
You can create a total like this
Using the formula
=SUMIFS([Opened Complaints]:[Opened Complaints], $[QT Week]:$[QT Week], >=1, $[QT Week]:$[QT Week], <=12)
and
=SUMIFS([Closed Complaints]:[Closed Complaints], $[QT Week]:$[QT Week], >=1, $[QT Week]:$[QT Week], <=12)
where 1 and 12 are the first and last weeks in the quarter.
Use this data to create your pie chart
-
Thank you very much for your assistance.
-
Happy to help!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
