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 using the calendar app for my team so they can see all scheduled events, but the default view shows quarters in the past (see screenshot). I want the calendar view to start in the current quarter and show future quarters but I can't figure out which setting needs to be updated for that. Can someone help?
Hello, am I correct in my understanding that if I need to have the Report filtered out by the "Current User", I still need to share the Source Sheet to the other user(s) by which the Report is derived from? In this case, how do I prevent sharing the confidential information of other users if I need to share the Source…
When shared to a sheet as an editor, an internal user got an an alert that "Recipients without a member seat may be limited to view access. If they are not a paid member, and they comment, edit . . . they may become a provisional member…" They show up under Seat Types & True-up as a paid Member; they are counted in our…
