-
Free Data Shuttle Webinar - March 16
Hello! We will be hosting a free webinar on March 16th "Intro to Data Shuttle." Join us here to learn how to automatically and seamlessly upload, or offload, data between Smartsheet and other tools.
-
CDATA import into Smartsheet cause apostrophe problem
We are using an external tool from CDATA to import data into Smartsheet from MS SSIS. We have recently run into an issue where the data load inserts an apostrophe in front of the string value we are loading. We've checked the outbound flow from SSIS and the apostrophe is definitely not there, so Smartsheet is doing this.…
-
Python API Library Started Throwing Error
Hi all, I've been using the Python API to update a sheet on a nightly basis. It's been working fine until a couple days ago (not sure exactly when). Now when I call smartsheet.Sheets.delete_rows(sheet_id, list_of_row_ids), I get the following json response: {"response": {"statusCode": 400, "reason": "Bad Request",…
-
Third Party API connectors (IPAAS) recomendations
I'm having a hard time finding a reliable third-party integration service. I have a master sheet with a dropdown menu that is used to order a product from another department in my company. When "request" is selected in the dropdown I need a new row added to another sheet with a few details from the original row. Then after…
-
Export only new rows from form submissions to excel
I have been searching for an automated way to get this done. I have a pretty intense (for me personally) form that my coworkers use to track a number of things that I measure. I am pretty married to my sheet and have a number of automated workflows running with it as well. There are about 48 columns of data including index…
-
It's possible to create a dynamic dropdown list in smartsheet form.
need to create a dynamic dropdown list in my Smartsheet form so that data automatically pull from data sheet into my form when user click any location or year.
-
Docusign / Smartsheet | Supported Field Types
Does anyone have experience working with DocuSign "Radio Groups" and merging those fields to data inside Smartsheet? I have been utilizing the Smartsheet/DocuSign integration for several months with great results, but there are a few areas I am running into issues - this being one. I have application forms that have…
-
Suggested or maximum payload size for Update Rows?
I've got a service that updates a sheet's rows with data from another source. It works fine on a sheet that has <5000 rows and around 19 columns, but I keep getting error 4002 whenever I'm trying the service with a sheet with >11000 rows. Is there a maximum number of row objects (and cell data) that is suggested to ensure…
-
Insert approvers name and date/ time of approval
Hi all, I have created a form and a workflow for approval. In short: Somone submits a form Details email to an approver Approver either approves or declines (would also be good to have more than 2 options i.e. defer) The smartsheet updates to say approved or declined What i cannot figure out how to do is show who approved…