-
Adding Predecessor That Includes Lag via API
I'm able to add predecessors to rows via API (PUT and URI https://api.smartsheet.com/2.0/sheets/{sheet ID}/rows), but am unable to add a lag value to the objectValue. I referenced: Is there any way to add or update the Predecessors column value by C# or Rest Api? — Smartsheet Community to build this. Kudos to @Genevieve P.…
-
Mobile view for Dynamic View?
Hi, Can dynamic views be accessed on smartphones/mobile devices? I don't see this option on the app.
-
QR Code Asset Management & Tracking
All - I'm looking for a rather complex solution and have had no luck searching for existing integrations and/or partners. Hoping the community has some good input here. What I'm ultimately looking for is to be able to automatically produce a QR code per row and then scan said QR code from a printed sticker attached to a…
-
How to provide access to specific sheets using a Smartsheet API access token?
What's the best approach to share a Smartsheet access token, generated through a service account, in a manner that restricts the recipient's access to all my sheets while ensuring the token has permission to access specific sheets? Regards, Klin
-
SmartSheet API call via Alteryx
Hello, I have recently built an Alteryx model to extract data from various smartsheets that I have access to. While the model does what it needs to do, the API call seems to work only on a random selection smartsheet IDs. As a first step, I am extracting the details of the smartsheets that I am given access to (just the…
-
How do I auto populate subtasks dependent on a main ''Task Title'' selected from a drop down list?
Afternoon, Basically I have a smartsheet to track marketing tasks and subtasks. I have some tasks, where when selected I'd like a list of subtasks to auto populate on seperate rows underneath the main task (and indent as well if possible) I've tried using the INDEX (COLLECT) function where when a specific task is selected…
-
Using Get Report activity in UiPath throws API error
In a UiPath automation, I am trying to get the contents from a report based on summary data from all sheets in a specific folder. I set up the scope and added the Get Report activity with the report ID from the target report. When I run the activity to test it it returns an error: "Error Code: [202] \r\n Message: The…
-
I have a single cell I want to auto-add the sum
I have a cell that is for quantity of material used. Say I put in 3000. Tomorrow I want to put 2000, instead of manually adding it together to get 5000, how can I make that cell auto-add to get 5000 and not have to add it manually together.
-
Bridge - Extract From Array - Key
I'm trying to extract the values from a row into a consolidated list. In this scenario I think I can use either the Get Sheet or Search Sheet node to identify my list of values, but I'm unsure of how to format the key in either scenario so all values are presented in a consolidated list. Could someone please help me figure…
-
Ability to use public facing ID in the permalink to access objects through the API
Smartsheet Objects (Sheet, Report, etc) consist of two identifiers, the object's ID and the public facing string found in the permalink (PUBLIC_ID). Example of a Permalink: https://app.smartsheet.com/sheets/{PUBLIC_ID}?view=grid Navigating to File, Properties a user can find the ID and the share url which contains a…
