-
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 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…
-
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…
-
Easier way to identify and transfer Premium App Assets from one user to another for System Admin
Currently there is no easy way to identify what premium app assets was created by the user who is leaving the company. (or left the company) System admin is not able to view assets created by the user for DataMesh Pivot Workapp System admin can view asset created by user but unable to transfer ownership: Data Shuttle Some…
-
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%.