-
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 Functions: MEDIAN, MINIMUM, MAXIMUM
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.
-
How do you create a pivot card in Pivot App and what is it?
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 normal login, however when I click on the calendar button, nothing happens. See screenshot. Can anyone help explain what a pivot…
-
Running a Pivot Table From the Mobile App
It would be helpful to be able to manually initiate a pivot update from the mobile app rather than having to go to the website.
-
Running a Pivot Table From the Mobile App
Is it possible to manually initiate a pivot update from the mobile app, or can that only be done from the website?
-
links to pivot sheet cells do not hold the link
I have created a pivot sheet. I then from another sheet link a cell to the pivot sheet but the link does not hold. This just started happening with newly created pivot sheets. I have a number of older pivot sheet created and the cell links are fine. I also use pivot cell links in my dashboard metrics, they are now coming…
-
Smartsheet Pivot is no longer replacing all the information on the target sheet
I created a Smartsheet Pivot that was working as expected for a couple months, and suddenly this week it stopped replacing all the information on the target grid like it used to (and needs to for my purposes). This pivot is meant to generate a fresh dataset in the target grid at an hourly cadence, that is then filtered…
-
Pivot App Available for Government Edition/Version
We utilize Smartsheet's to allow for collaboration, reporting, and dashboarding across various entities. It would be useful to allow a pivot app option in the government edition/version to summarize content for managers/stakeholders and would be useful for summarizing data for use in other Smartsheet developed dashboards…