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.
Hi everyone, Since today, June 24, 2026, our Smartsheet automated emails have stopped working. Alert notifications and Approval Requests that were being delivered normally until yesterday are no longer reaching any recipients. We have not made any changes to our workflows or automation settings. We have also checked spam…
Hi - We noticed that our workflow automations (specifically update requests), stopped working. When we look it says pending but nothing is being sent to the contact nor is it appearing in their notifications. When I run a test it works fine :-(. Notifications on the same sheet are fine. Is anyone else seeing issues.
Since approximately 14 hours ago, no users in our organization have been receiving Smartsheet notifications. The issue affects: Approval requests Update requests Automated alerts Reminders Email notifications In-app notifications We have tested workflows that have been working correctly for months, as well as newly created…
