-
Pivot Table Summaries Getting #REF Error?
I have a few pivot tables set to update weekly, and seem to be refreshing the actual numbers just fine. However, I have some summary functions set up that have totally stopped working, instead giving a #REF Error: I'm a little surprised, as it worked perfectly (with real cell references, not #REFs) when I originally set it…
-
Help Article updates
Hello Community, We’ve published the following new content: File library File library sharing permissions Get started with Smartsheet Pivot App Features of User Subscription Model vs Legacy Collaborator Model Determine the model your plan is on To view the entire catalog of help articles, visit the Help and Learning…
-
Charts Should Grow When New Pivot Values Added
Currently, if a new pivot value is added to a pivot table, the new value doesn't automatically pull in to a dashboard chart. You have to go and edit the dashboard chart to now pull in the new value. It would be nice if you could point the dashboard chart to the pivot table as a whole, so that when that pivot table grows,…
-
Copy Pivot Table
Please vote this up! FEATURE REQUEST ALERT! 2 things: I would like the ability in the Pivot App, to "COPY" a pivot table so that it doesn't have to be recreated from scratch every time. It's a waste of time and has too much room for human error, especially when trying to organize and create data for hundreds of metrics. It…
-
Multiple Pivot Tables on A Sheet
In Excel, when you build a Pivot table, you can tell the workbook WHERE you want the pivot to live. If we can add the functionality to Smartsheet so we can have multiple pivots per sheet, that would be extremely helpful, because then I can build my dashboard charts from ONE SHEET vs. from MANY sheets. Happy to discuss…
-
Add Ability to Filter a Pivot Table on Pivot App
The Pivot app functionality is VERY basic. I was surprised to learn that when you are building a pivot table, you can't even add a filter to the pivot. Please include this functionality. The suggestion I was given is to built the pivot off of a filtered report. But then I would need to create so many different reports…
-
Assets in Calendar & Pivot Apps now support multiple admins
Hi Community, We’re excited to share that within Calendar and Pivot Apps - individual assets now support multiple admins! With this new release, all users that are admins on an asset's underlying sheet or report are automatically admins on the asset itself! This makes it easier than ever to manage assets in Calendar and…
-
Pivot App creating unwanted columns filled with 0's
I am baffled by the behavior of one of our Pivot tables. When we run the pivot, we receive unexplained columns filled with 0's. Here's the source report, a report of outstanding tasks and their End Months: We used the Pivot app to view the End Month as columns and this is the result: The problem is the first column: "2023…
-
Help Article updates: September 2024
Hello Community, We’ve published the following new articles: Create solutions from scratch or by choosing a template with Global Create Get started with Smartsheet Pivot App To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback at the…
-
Why can't I transfer Pivot ownership?
I am trying to transfer the ownership of a few pivots to a different manager within our organization. When attempting the transfer I get the message "Error! Target user doesn't have sufficient sheet/report access". I checked the destination sheet to give the new manager permission and he already has admin permissions. I…
