-
Extend decimals in the Pivot App
PivotApp currently only extends two decimal points, so when calculating percentages, we only see the rounded whole number. Please extend to at least four decimal points so more specific data points can be collected. Current state .25 or 25%. Future state .2557 or 25.57%.
-
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
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…