Preview, build, and edit a Pivot table

Preview and build the Pivot table

If you want to preview the Pivot table and build it immediately:

1. Select the Pivot you want to work with under Name.
2. Follow the steps in the wizard. 
   

Once you’re in the wizard

1. Select Preview to review the details of your Pivot.

This takes you to Step 2 of the wizard and shows you a preview of the Pivot you’re creating in Smartsheet.

2. Review the results of the Pivot. If you like what you see, select Confirm.

To make changes, select Cancel and then the gear icon to edit the Pivot.

3. The Pivot App builds the Pivot sheet and puts it in the location you specified in Smartsheet when you created the Pivot.
4. Select Close.

You’ve now created a Pivot sheet, which you can find in Smartsheet.

Find the Pivot table sheet in Smartsheet

1. Open Smartsheet.
2. You can search for the sheet by name or locate the destination workspace or folder you specified when you set up the Pivot sheet.

You may need to refresh your browser to see the new sheet.

Organize and format the Pivot sheet

Initially, the Pivot table doesn’t have formatting. Rows appear alphabetically. You can rename the columns and use the formatting tools in Smartsheet to make the Pivot table look the way you like.

Formatting and new column names persist even when you’ve made data changes, added new rows to the table, or set up your Pivot table to refresh automatically.

Edit a Pivot sheet

1. Select the gear icon to edit and make changes to the Pivot sheet.
2. Apply your desired changes.

Transfer ownership of a Pivot sheet

To give ownership of one or more Pivot sheets to someone else:

1. In the Smartsheet app, check if the person you’re transferring the Pivot sheet to is an Admin in all of the following:
   • The source sheet or report for the Pivot table
   • The Pivot table sheet
2. Open the Pivot App.
3. Find the name of the Pivot sheet for which you want to transfer ownership.
4. Select the Transfer icon (two arrows).
5. Type the new owner's email address.
6. Select Transfer.