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've "starred" the lines I wish to be viewed in calendar view. I've clicked on Calendar view, filtered by starred items, went to File, Send as Attachment, entered my email, selected the PDF option and hit send. When I receive the email with the PDF attachment, the PDF will not open. It acts like it's going to but will not.…
How can I add pages to an intake form? I created an intake form that contains over 50 questions ad I would like to split them up into 5 pages of 10 questions but I'm unsure how to add pages within the Smartsheet form. Any help would be appreciated
A former employee has returned to work with us as a contractor. Her old company email is still in various Smartsheet workspaces. When I delete it and attempt to re-share the sheet to her contractor email, I get a popup saying "You're sharing to people who have multiple email addresses. You'll be sharing this workspace to…
