-
Pivot App doesn't allow date columns?
I have a source sheet that has the following columns: Project Code , Milestone and Milestone Date . I want to use the Pivot app so that it gives me a row for each project code, columns of Milestones and the corresponding dates for those milestones. Am I correct in understanding that the Pivot app cannot output dates? I…
-
Pivot Table using Sheet Summary Report #2
Can I use a summary report as a source for pivot table? I need to include different sheet names as columns and add the products for each one of them. I had a pivot using a summary report and it was working as of yesterday but now is not and I cannot recreate it!!! HELP!
-
Add "Notes" attribute to meshes and pivots
It can be difficult to track the full flow of a process from end to end via meshes and pivots. If a new "notes" attribute could be added to both mesh and pivot configurations, the users could add some brief documentation to help later maintenance/tracing.
-
Pivot App is not recognizing the Contact Columns
We had a lot of pivot tables built from Contact columns but all were showing blank now, when I test manually by creating a new pivots I see contacts columns were not recognizing in the pivot apps, all summaries were grouped under the Blank row. Here is my example eCOA Implementation PM is a contact column and have lot of…
-
Enhancement Suggestion: Pivot Table Feature
Introduce a pivot table feature within Smartsheet to empower users with enhanced data analysis capabilities directly within their sheets. This feature will enable users to summarize and analyze data dynamically, similar to Excel pivot tables, thereby streamlining analysis workflows and enhancing productivity. The Pivot app…
-
[Closed] Share Your Pivot App Experience & Earn a Gift Card!
Hi Smartsheet Community, The Pivot App team is inviting users to participate in research interviews to help us improve the Pivot App. We're interested in understanding how you use it and how it fits into your daily work. Your feedback is invaluable, and we'll thank you with a gift card for your time. Ready to contribute?…
-
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…
-
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…
-
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 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,…
-
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…
-
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…
-
Pivot- Faltan columnas asignadas
¡Hola a tod@s! Estoy intentado hacer el Pivot de un informe y siempre me salen mensajes de error (pongo un par de capturas de ejemplos). Pruebe con las columnas que pruebe, me sale ese mensaje "Faltan columnas asignadas". Le dije a mi compañero que probara en el mismo espacio de trabajo y haciendo los mismos pasos que yo y…
-
Reverse the Ranking Order
I am working on ranking clients based on revenue with the highest revenue being number 1. In the end I want to build a top 25 list that could change on any given day based on new data. I used this formula to rank my items: =RANKEQ([Lost Client-SUM-BI Estimated Annual Revenue]@row, [Lost Client-SUM-BI Estimated Annual…