-
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…
-
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…
-
API "Search" Endpoint: Offline?
Is the "search" API endpoint nonfunctional at present? All other endpoints seem to be functional on my end (sheets, folders, etc.). This has been tested with both the requests library in Python and in Power Query web requests in Power BI. PQ web requests returns a 500 internal server error. The Python web request returns…
-
Automate sheet creation
Can I use automation to trigger the creation of a new sheet? Here's the situation. I have a form that adds a new row to a sheet. I would like to evaluate the primary key's value against what already exists in sheet and do one of two things: if the value already exists add the row to the existing sheet for that primary…
