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 …
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 100…
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 Coun…
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…
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 t…
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 i…
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 becaus…
I am new to Smartsheet's pivot app. I normally use the Log in with Smartsheet button in the Pivot App to create a pivot table but I wanted to try the "Pivot Card - Create a Pivot card" below the norma…