The Smartsheet Pivot App helps you summarize and analyze large data stored in sheets or reports and create meaningful comparisons, patterns, and trends.
Get Started with Smartsheet Pivot App
The Smartsheet Pivot App is a premium add-on that helps you summarize and dynamically refresh data that you’ve stored in a sheet. With the Pivot App, you can create a pivot table that allows you to:
- Create rollup summaries and surface key information across multiple sheets
- Keep summary metrics up to date as new data is added
- Quickly identify and adapt key segments as your data needs change
For example, with Pivot App, you can take data that looks like this
and make it look like this:
Smartsheet Pivot App is a premium add-on and is available for purchase. For more information about how to obtain Smartsheet Premium Apps, please contact Smartsheet Sales.
Before You Begin
In order to use the Pivot App, you must be a licensed Smartsheet user on a plan that includes the Pivot App.
The Pivot App leverages existing Smartsheet data. To create a pivot table in the Pivot App, you’ll first need to have your source data ready in a sheet or report to which you have Owner- or Admin-level sharing permissions.
Log in to the Pivot App
Click the Launcher to access the App.
NOTE: If you have trouble accessing the app from the Launcher, please see Access Premium Apps and Templates With the Launcher.
Create a Pivot Sheet
You’ll create new Pivot Sheets in the Create New wizard. There are four steps in the creation process.
To start the wizard, click Create pivot sheet in the upper-left corner of the Pivot App and then follow the steps in the wizard.
Step 1: Select Sheet
- Search or browse to find the sheet or report that contains the data that you want to summarize.
- Once you locate the desired sheet or report, select it and click Next.
Once you commit to a source sheet for the pivot sheet, you can’t change it. If you want to create a pivot from data from a different sheet, you’ll need to start a new pivot sheet.
TIP: Consider using a report as the source of your pivot so that you can add or remove criteria or create a pivot from multiple sheets. For more information about reports, see Use Reports to Organize Data.
Step 2: Assign Columns
In the Assign Columns step, you’ll choose the rows, columns, and values that you want to appear in your Pivot Sheet. You’ll also give your table a name and indicate whether and how often you’d like the table refreshed from the source data.
- Click Add Field above the Columns,Rows, and Values boxes to select the source for those items in the Pivot Sheet.
TIP: Use the guide below to help you decide what goes where.
- In the Pivot name box, type a name for your pivot sheet.
This is the name that the Pivot App will give to the pivot. You’ll use this name to distinguish this pivot from others that you create in the App.
- In Execution Frequency, select how often you want the table to be updated (you’ll need to select an option here if you want your pivot table to be updated periodically to reflect changes in the source data).
Guide for Column, Row, and Value Placement
Use the image below to help you decide how to position the data in your pivot table.
- Columns The fields you add to the Columns box will be the values across the top of your pivot table (calendar months for example).
- Rows The fields you add to the Rows box will appear on the left side of the pivot table. If you add multiple fields, you’ll create hierarchies. The hierarchy is driven by the order in which the fields appear in the Rows box.
- Values The fields you add to Values will appear at the intersection between the rows and columns of the pivot table. These values can be sums, averages, or counts.
Step 3: Destination
In this step, you’ll specify a name for the new pivot sheet and specify a destination in Smartsheet for it.
- In the Sheet name box, type the name for the destination sheet.
- Under Select destination folder or workspace, select where you’d like the Pivot App to put the new pivot table.
- Click Next and then click Create to set up the pivot instructions in the Pivot App.
If you’ve set an Execution Frequency (in the "Step 2" section above), the pivot table will be built at the next scheduled run time. To preview and create the pivot table right away, follow the steps in the next section of this article to build the pivot table and create a sheet for it in Smartsheet.
Preview and Build the Pivot Table
If you want to preview the pivot table and build it immediately, you can do that by clicking the link for the pivot that you want to work with and following the steps in the wizard. Start by clicking the name of the pivot under Name.
Step 1: Details
Click Preview to review the details of your pivot. The wizard will advance to step 2 and show you a preview of the pivot that will be created in Smartsheet.
Step 2: Preview
This step allows you to see the results of the pivot. If you like what you see, click Confirm. (If you need to make changes, click Cancel and follow the steps in "Edit a Pivot Sheet" below.)
The Pivot App will build the pivot sheet and put it in Smartsheet in the location that you specified in Create a Pivot Sheet (Step 3: Destination).
Step 3: Confirm
Congratulations! If you made it this far, a pivot sheet has been created and should be waiting for you in Smartsheet. Click Close to close the wizard.
Edit a Pivot Sheet
If you need to make changes to the pivot sheet (for example, if you get to the preview stage and you realize that you forgot a column, or that you want to show the rows using a different hierarchy), you can do that by clicking the Edit icon.
Find the Pivot Table Sheet in Smartsheet
To find the new pivot table sheet:
- Open Smartsheet (https://app.smartsheet.com).
- Search for the sheet by name or locate the destination workspace or folder that you specified when you set up the pivot sheet (Step 3: Destination).
NOTE: You may need to refresh your browser to see the new sheet.
Organize and Format the Pivot Sheet
Initially, the pivot table will not have any formatting. Rows will be organized alphabetically.
You can rename the columns and use the formatting tools in Smartsheet to make the pivot table look the way you like. (For more information about formatting in Smartsheet, see Formatting Options. For information about renaming columns, see Insert, Delete, or Rename Columns.)
NOTE: Formatting and new column names will persist even if you have set up your pivot table to be refreshed automatically.
Note that the formatting will persist even when data changes or new rows are added to the table.
Transfer Ownership of a Pivot Sheet
If you change roles and need to give ownership of one or more pivot sheets to someone else, here’s how to do that:
- From Smartsheet, make sure that the person who you’ll be transferring the pivot sheet to has Admin-level sharing access to the following:
- The source sheet or report for the pivot table
- The pivot table sheet
- Open the Pivot App (https://pivot.smartsheetapps.com/).
- Under Name, find the name of the Pivot Sheet for which you want to transfer ownership.
- Click Transfer Ownership.
- In the Ownership Transfer window, type the email address of the person that you want to transfer ownership to and click Transfer.