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.
My user is in view only and we can't change it. My user was granted enterprise access and I've request admin access and been assigned it but my user still is view only. I was able to to do everything and I had to renew my license on my user, which is fixed. Sheets that I had created I can't even edit.
Is there a RACI template that Smartsheets already has or does anyone have any suggestions?
I have a number of forms created and one of the fields is a contact list. When I am in the sheet I am able to start typing a name and it offers suggestions and then links to that persons contact. When I try to do the same thing in a form it does not offer the suggestion and then does not link to the contact in the sheet.…
