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.
hi would like to create a simple patient tracking system for our small clinic where i can record the time & duration a patient appeared in our establishment. Using a central sheet where it records all the data to be accessible by the admin. There will also be Four (4) forms to be accessible by the three department. Concept…
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…
