-
Confused about API and access levels
Hello, I am trying to perform a workflow where I: Make a request to list all sheets For this step, I am using this endpoint: `https://api.smartsheet.com/2.0/sheets?includeAll=true` Choose a sheet Make a second request to get more information about that sheet using the sheet id from the first step For this step, I am using…
-
Bridge - Pull Multiple contacts from one sheet & update one cell with all?
I am trying to use Bridge to pull all the contacts (Supervisors) from a roster grid that match the department defined by my trigger and then put all of these contacts into one single cell on my project tracking grid. So far, I've been able to get the array and then extract the emails I would need but there's a couple…
-
How can I stop a Bridge workflow?
I'm making a Bridge workflow to bulk unshare assets with users. It uses multiple child workflows and API calls. My latest run has been stuck on waiting, even though I have… stopped it at every level revoked API access deleted the API profile How can I get the workflow to stop? It won't let me run it while it's waiting, so…
-
startingNumber ignored?
I appear to be having the same issue as described in this post from 2021. PUT { "type": "TEXT_NUMBER", "systemColumnType": "AUTO_NUMBER", "index": 1, "title": "Auto", "autoNumberFormat": { "prefix": "10", "fill": "000", "startingNumber": 1, "suffix": "" } } is returning { "message": "SUCCESS", "resultCode": 0, "version":…
-
Moved: Approval Requests Automatically Triggering on Email Click – Still Looking for a Solution
This discussion has been moved.
-
Pull Data from Power Bi to Smartsheet
Hi, I would like to integrate Power bi with Smartsheet and pull the data on the tables on Power bi to Smartsheet. Is there a way to make this connection ? The reason i need to do this is to make my employee see the data through Smartsheet not from Power bi. Thank you.
-
Webhook delay with attachments (1-2hours!)
Hello! I'm using webhooks to notify me when a file is attached either to a sheet or a row. Sometimes I get a notification after the usual delay of ~1 minute, however I regularly see cases where there is a delay of around 1-2 hours. I don't see this delay when making row/cell changes to the sheet. I always get the webhook…
-
Snowflake Data into Smartsheet?
Hey everyone, Do you know if there is a way to connect Snowflake data into Smartsheet using the API? I have found many resources on getting Smartsheet data into Snowflake but nothing on the other way around. We are trying to either do something native within Smartsheet or use an open-source software such as Airbyte.
-
Cell last update timestamp from api
Hi, Is there a way to get a cell last update datetime from api, that is not using get_cell_history? I'm asking because get_cell_history is an expensive call (takes 10 tokens).
-
PowerAutomate - Insert row
I am using the the Smartsheet Connector in Power Automate. It all works fine, if I am using "insert row" with a fixed sheet name. But if i want to use a dynamic sheet ID, am ask for row Can anybody help me, what values in which format I have to put in this field. I could not find any documentation.