Sign in to join the conversation:
Hi all,
How can I create a PivotTable on smartsheet? for create like this graph in attachment
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
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
You create referencing matrixes on smartsheet or on others app (Excel or Google Spreadsheet ...)?
I use smartsheet If you go to a dashboard and add a widget is is very easy to follow the steps to create one.
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.
I have a sheet that is shared by many users, needless to stay can get messy when this many people in a sheet, saving, adding statuses, etc. and no we cannot use table view at this time, it doesn't work for this sheet. In this sheet I have "pending orders" which are only relevant to me, as orders come in they become active…
I created an intake form to manage all the requests my team receives. The first question on the form is "request type" with 5 different options available. Based on the users selection, all relevant fields for that type of request are shown to user to fill out. So this form was fairly complex to setup with all the…
It looks like around an hour ago, all of the files in subfolders moved into the main Workspace folders? Is anyone else experiencing this or is it an issue for just me? I moved some of them back to the correct subfolder and refreshed and they are back in the main folder. Help!
