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.
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
