-
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…
-
Export meta data from Reports (count functions etc)
Hi Friends, I am trying to create some analysis tools at work, assume the following scenario: I have a smartsheet filled by an online form employees fill out. Each form filled and sent creates a new row in my sheet. columns like Name Location Date of entry dropdown value a dropdown value b How can I count entries and have…
