Where is the table button?

FGCC Smartsheet

1. Open the sheet containing your data.
2. Select the range of cells containing your data.
3. Click on the “Table” button in the top menu bar. The button looks like a grid of cells with a thick border around it.
4. Choose “Create Table” from the drop-down menu.
5. In the “Create Table” dialog box, select the “My table has headers” checkbox.
6. Enter a name for your table in the “Table Name” field.
7. Click “Create”.

KPH

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

KPH

🤔 Those sound like instructions for Excel, not smartsheet. What are you trying to do?

FGCC Smartsheet

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?

KPH

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

FGCC Smartsheet

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.

KPH

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?

FGCC Smartsheet

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.

KPH

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

FGCC Smartsheet

Thank you very much for your assistance.

KPH

Happy to help!