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'm on the bussiness plan. We have 8 team leaders who are licensed users on the legacy model. Other people on the organization are collaborators who occasionally update task status and comment on rows. This updates are sometimes done through forms and sometimes directly on the grid view. We also have people from outside…
Hi There Can you please assist me in loading files when submitting a form. Is there any other way to upload more than 10 files as Smartsheet file uploads only submits 10 files as i need to upload more than 10 files from the form.
Hi Team, I notice when I initially submit an email from the Dynamic View to the submitter, a notification isn't triggered to them of my comments, but I receive an email when the submitter replies back to me. I had the submitter check their spam and junk folders for my email, but it wasn't available. Is there a solution for…
