nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

PivotTable

Adil-Dkaki

Hi all,

How can I create a PivotTable on smartsheet? for create like this graph in attachment

Find more posts tagged with

Dashboards

Comments

L_123

https://pivot.smartsheetapps.com/

It isn't my favorite thing though. I much prefer referencing matrixes in my sheets to build charts such as what you posted, which can be done in a dashboard

Chris McKay

Hi Luke,

The Pivot App does have its place and offers some conveniences over what can be achieved by indexing named ranges, using cross-sheet references etc.

But it is not cheap at ~$2,000 so is only applicable to certain organisations/users.

Kind regards,

Chris McKay

Adil-Dkaki

Hi Luke,

You create referencing matrixes on smartsheet or on others app (Excel or Google Spreadsheet ...)?

L_123

I use smartsheet If you go to a dashboard and add a widget is is very easy to follow the steps to create one.

rdobson

We've manually created a separate 'Pivot' sheet that does cross-sheet calculations to drive dashboard graphs and widgets. Like the screenshot attached. A nice new addition to the graphs means we can pick which particular series of data to include and which to exclude from the graph.

Sign in to join the conversation!

Quick Links

Trending discussions

Data is missing
Hello, I created a Smartsheet Project yesterday (trial 30 day user). I input all relevant information including due dates, status, priority, etc. I returned from work just now and logged in to update something on the sheet and all info is missing. I can see the Project Folder but all rows are empty. I tried troubleshooting…
Can you do a portfolio report on manually created project sheets?
I have a portfolio with 1 project template. I created 2 projects from the project template. I realized I need a Project Metadata sheet to facilitate the portfolio reporting I need. So I added a Project Metadata sheet to the project template and manually to the 2 projects previous created from the template. I've confirmed…
Users incorrectly labelled as "External"
Hi Smartsheet users. We have a number of users who are being labelled in the "Seat types and true up" screen as "External". They all have the same email domain, which is different from the domain of users who are not flagged as External, however both domains belong to our company and are listed as verified under the…