-
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…
-
Utilize Pivot App for cashflow from multiple milestones
I have a sheet that tracks milestone payments associated with a specific type of project contract. Each row is a contract and columns are payment dates or amounts (see screenshot below). There are up to 5 milestone payments for each contract resulting in 5 pairs of columns (date and amount). I was hoping to use Pivot App…
-
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…
-
Pivot 1008 Error
Hello, I am encountering an error with one of my pivots. I am unsure what could be causing the issue as I have another pivot that uses the same source data and is able to run correctly. Error code 1008 (Ref: 9dcd06e0-9679-4c94-9838-8ab7c531c75d): Unable to parse request. Config: Run Log:
-
Pivot App help
Is there a way to create a pivot table without it turning the columns into a hierarchy? I simply want my 4 categories along the left (with no hierarchy) with years across the top. The middle is a Count of rows for each Year/Category combo. Also, can I force the pivot to group all like rows? I am getting a row for Category…
-
Pivot App
I would like to use the pivot app. I have a business license. I don't see the pivot app in my app list. I also don't see it in the manage app menu. How do I get access.
-
Clicking into Data in pivots
Hi all, does Smartsheet have the capability of clicking into data in pivots. For example in the image below if I were like to view the 35 items in column two. In excel I can just click the 35 and then it would populate a sheet with all of them. Does Smartsheet have that capability?
-
How do I create a report that is a pivot of duplicate items, with a status?
Hello! I have a tracker that consists of multiple contacts per client resulting in duplicate names for a single client, however, a single "status" column that covers the client. I am trying to pivot the client and status however, am struggling to figure this out. I would like to create a report by status that I can then…
-
Pivot App Added Functionality
This is a request to expand the PivotApp functionality to include additional ways of calculating metrics. Currently, "COUNT," "SUM," and "MEAN" are the only options. Additional options, which appear in comparable/competing products, would include "MEDIAN," "MINIMUM," and "MAXIMUM," among others. Please add on this…
-
Pivot App: Duplicate / Old Rows not being removed
Has anyone had an issue with old rows not being clearer out of a sheet generated by a Pivot? My only remedy so far is to delete all rows and re-run the pivot. Im thinking its a processing issue because it occurs with larger data sets.