-
Pivot- Faltan columnas asignadas
¡Hola a tod@s! Estoy intentado hacer el Pivot de un informe y siempre me salen mensajes de error (pongo un par de capturas de ejemplos). Pruebe con las columnas que pruebe, me sale ese mensaje "Faltan columnas asignadas". Le dije a mi compañero que probara en el mismo espacio de trabajo y haciendo los mismos pasos que yo y…
-
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…
-
Reverse the Ranking Order
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…
-
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.
-
Is it possible to trigger a pivot table to run from a dashboard?
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?
-
Add Pivot Table Functionality without extra subscription fees
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.
-
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 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…
-
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?
