-
Number values containing 'Apostrophe after being imported from Excel
Greetings All ! looking for some assistance regarding an integration issue I've picked up when importing data from Excel to Smartsheet's using MS FLow , i.e. Excel->MS Flow-> Smartsheet I am inserting an integer but the value on Smartsheet contains an apostrophe before the number which is not ideal as i am using these…
-
How to write to a Smartsheet column with dropdown list column type and with restricted selection.
I am encountering an error while attempting to input data into a Smartsheet column characterized by a dropdown list column type that enforces restricted selection from a predefined list. The error message is as follows: {"response": {"statusCode": 400, "reason": "Bad Request", "content": {"detail": {"index": 0, "rowId":…
-
403 Forbidden: Writing Over Automated Columns, Specifically Baselines
Hello all, I'm trying to use Alteryx to update baseline values for line items that were added after the baseline reset. I've successfully written into Smartsheet before; however, I believe the reason I'm unable to now is because these columns are automated. Is there a work around to this? The error that pops-up is…
-
Issues with DDUpdate?
Hi SS Community, Are any of you out there using ddupdate.com to support populating your dropdowns from a column in another sheet? Several people in my org are having trouble getting our payments to go through and are hearing nothing from the site. Is this just us or is it a wider problem with ddupdate?
-
Can anyone help with the Dashboard api?
The sight object exposes Widgets as a get and a set. public IList<Widget> Widgets { get { return widgets; } set { widgets = value; } } When you update the Sight you get a JSON error. The API documentation states Update is for a dashboard name change - this does work ok. Can anyone confirm whether you can or cannot update…
-
Subscope for row update webhook
Hello, I am trying to create a webhook that is triggered by a row update in my sheet. I would like to limit the event to a subscope of columns so that the webhook only fires when a cell in certain columns is updated. I am using make.com, and set up the webhook as object type: row, event type: update, and the selection of…
-
Bridge and FedEx Module - Authentication Problem
I'm getting an authentication connect issue when trying to run the FedEx Module step in my Bridge job flow. I set up a FedEx Developer Account and created a test new project. When I run the Bridge job I get an error on on the Module run saying, "failed to execute extension module : Authentication Failed". I mapped the…
-
Issue with row "new event" trigger
Hi there, I am using make.com (formerly integromat) to update an external database whenever a row in my smartsheet is updated. The automation is set up so that whenever a row is updated, I get the row (all of the cells) and then send that data to update my database. I only need this to trigger when a cell value is changed.…
-
Is there any way to get a sheetID from the KEY retrieved from a sheet access report?
I am a system admin, and we recently had to let go of our other system admin. I am trying to find out what sheets he had access to that I didn't, so I could could access to those sheets. The only way I can compare what I have access to versus was he had access to was a sheet access report, which has a sheet Key, not the…
-
Workaround for PowerBI Navigator record limit
Problem statement: When looking to utilise PowerBI via the Live Data Connector I was unable to find the sheets I wanted to connect. Cause: The PowerBI Navigator will return a maximum of 10,000 records from a given source. Workaround: I've managed to work around this by setting up a second DSN connection for the Live Data…
