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

COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
When a new row is created in Smartsheet, Create SharePoint List Item
I'm trying to do my first Smartsheet Power Automate flow. I've created a SharePoint list to hold the data. When a new row is added to a Smartsheet, I would like for that row of data to be used to create a new item in a SharePoint List. The part that I need help with is the mapping of the columns from the SharePoint Create…
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,

API & Developers

Discussion List