API & Developers

Archives for July 2020

Excel and Smartsheet linking
Hello I am working on a project wherein I have to extract most of the data from Excel to Smartsheet, is there anyway I can create linking between Excel and Smartsheet in such a way that whenever excel is updated Smartsheet automatically gets updated.
Is it possible to export a sheet as forms?
We often need to publish a report pulling data from a selection of columns, for a single row, sequentially on a page, and then the next row, etc (I.e. laid out like a document, not a spreadsheet). We currently use the Smartsheet add-on in google docs to do this, but it is frustrating and time consuming. Essentially what we…
Import Excel Data automatically
Hello Experts, We are currently exporting excel file from SAP to Desktop and the same file is being manually fed in smart sheets to accommodate the existing charts on daily basis to update. As of I don't find any plugin to correct SuccessFactors directly. Please suggest if there is any option in Smart sheet to…
Automate io & Deleting Data from Smartsheet
I just recently started using automate io and just recently ran into some major issues. Automate io allows you to create a bot with the trigger of 'New Row' so anytime a new row is created on a sheet, it will trigger the bot. Soon after setting it up, my bot stopped triggering, every time I created a new row (using a…
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.…
SharePoint to Smartsheet Integration Using Power Automate
Let me start by acknowledging that I am a complete API/Power Automate novice. However, I am trying to create an automated method to trigger my Smartsheet workflow when my client posts a document to a SharePoint folder (serving as a central repository). After some preliminary research, it appears that Power Automate may be…
Value for updating a checkbox
Hello, I am trying to pass in values via Zapier to update a checkbox type field. I have restricted the column so that it will only accept checkbox values. What value should I pass in to check/uncheck the box? I have tried Yes, No, True, False, and some variations in all caps. Thanks! -Zac
Smartsheet Integromat Integration
Hi Community, Does anyone have experience using Integromat to copy an entire Smartsheet folder with everything in it, when a new row is added to a specific sheet? I need help setting the integration up. Thanks
I have been asked to pull in leads using JSON Hook, can you help?
Hello, I have been asked to pull in leads using a JSON hook for Home Advisor leads and I am not sure how to do this or who to ask for help. Can you please send me in the right direction? Please see the attached document they sent me with directions. I need help understanding this information or suggestions on where to go…
Azure logic app & Smartsheet webhooks
Can you provide sample to register webbooks in logic app? I'm passing below information but on return I get webhook enabled = false.. I again make put call to enable particular webhook but it doesn't seems working

Trending in API & Developers

QR Codes/Bar Codes
Dear Smartsheet Community. Is there a means within Smartsheet to allocate a unique QR/Bar Code to a specific line in a grid, such that if you subsequently scan the code (outside of Smartsheet), the specific line/data record can be accessed? For now, I am thinking of an image of the relevant code added in a cell as an…
Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…
Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…

API & Developers

Discussion List