-
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…
-
Aderant integrations
Has anyone used Aderant API or data to sync with Smartsheet financial data? I'm curious on the connectors available or if only a token is required.
-
Smartsheet Automations and API/Webhook Calls
Hi there, We have a sheet then when an item in the sheet is marked as complete it is moved to an Archive sheet using Automation. The problem is there is so much data in a short period of time that we hit the sheet cell limit and have to export the data out into a CSV. I am wondering if there is a way using automation to…
-
Issue in using Smartsheet CSharp SDK in SSIS Package
Hi, I am using Smartsheet CSharp SDK in SSIS Script Task. I added it by nuget package, but getting error as below : Error CS0246 The type or namespace name 'Smartsheet' could not be found (are you missing a using directive or an assembly reference?) Then, I downloaded Smartsheet CSharp SDK and added reference to the dll…