API & Developers

Archives for July 2020

Discussion List

  • Excel and Smartsheet linking
    In API & Developers
    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 g…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by RossL API & Developers
  • Is it possible to export a sheet as forms?
    In API & Developers
    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 …
    Accepted
    22 3
    Accepted Answer 22 views 3 comments Most recent by Andrée Starå API & Developers
  • Import Excel Data automatically
    In API & Developers
    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 SuccessF…
    Answered - Pending Review
    53 7
    Answered - Pending Review 53 views 7 comments Most recent by Andrée Starå API & Developers
  • Automate io & Deleting Data from Smartsheet
    In API & Developers
    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 se…
    Answered - Pending Review
    23 5
    Answered - Pending Review 23 views 5 comments Most recent by Andrée Starå API & Developers
  • CDATA import into Smartsheet cause apostrophe problem
    In API & Developers
    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…
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Ben G API & Developers
  • SharePoint to Smartsheet Integration Using Power Automate
    In API & Developers
    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…
    Answered - Pending Review
    83 3
    Answered - Pending Review 83 views 3 comments Most recent by Ben G API & Developers
  • Value for updating a checkbox
    In API & Developers
    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,…
    Answered - Pending Review
    43 1
    Answered - Pending Review 43 views 1 comment Most recent by Genevieve P API & Developers
  • Smartsheet Integromat Integration
    In API & Developers
    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
    Answered - Pending Review
    32 1
    Answered - Pending Review 32 views 1 comment Most recent by Ben G API & Developers
  • I have been asked to pull in leads using JSON Hook, can you help?
    In API & Developers
    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 d…
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Ben G API & Developers
  • Azure logic app & Smartsheet webhooks
    In API & Developers
    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 (Image)
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Ben G API & Developers