PivotTable

Adil-Dkaki · 04/23/18

Hi all,

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

L_123 · 04/23/18

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 · 04/23/18

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 · 04/24/18

Hi Luke,

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

L_123 · 04/24/18

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 · 04/24/18

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.

PivotTable

Comments

Categories