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…
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…
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.
I'm setting up a dashboard to manage a process and would like to be able to insert a widget that will force a pivot table to run? Is it possible to get a URL for a pivot table?
Please add Pivot Table functionality to the basic Smartsheet plan. Smartsheet is marketed as a smarter spreadsheet but lacks the basic functionality that comes with Excel and Google Sheets. It's difficult to transition at an enterprise level when essential tools are add-ons with extra fees for use.
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…
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:
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…
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?
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…
