-
Allow Grouping of Dates by Month/Year Year in Pivot Table App
I know we can achieve this with helper columns in sheets, but I think it would still be a game changer if we could design Pivot tables that allowed grouping/summarising of dates by Month/Year without needing to edit all the sheets to include a helper column. If we could do these sorts of date logics directly in the Pivot…
-
Rank Pivot Results WITHOUT DUPLICATES
Hey friends, I am trying to create a column that ranks (without duplicates) the results of a PIVOT configuration. The PIVOT config produces the SUM of rental dollars spent, in column "Grand Total-SUM 💲 Total Rental $ Amount {H}" respective to each listed equipment type, in column "⚠️Cat-Class Description". I'd like to rank…
-
Pivot App is just clocking and not creating a pivot table for me
I am trying to create a simple pivot table that shows project planned spend and project actual spend by month from a project sheet. My Planned Spend and Actual Spend columns are calculated in the worksheet (each row calculates task cost by multiplying "resource hours" x "resource cost") and I added a column to indicate the…
-
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 - November 2024
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…