API & Developers

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

Extending set of standard functions?

edited 02/12/25 in API & Developers

Is there anything in the Smartsheet APIs that would allow a developer to add new functions to the standard set of functions? We'd like to dynamically retrieve data from an external system via user-defined functions, similar to what can be done with another popular spreadsheet app.

Answers

  • ✭✭✭✭✭✭

    Not sure exactly what you are looking for but Data Shuttle allows you to import and update data from another source via a csv file. You can also export and import between smartsheets and export a csv file out all with filters rather than the whole file.

    For example our core SAP system holds all our master product data but it would be really useful to access some of this within Smartsheet.

    Therefore I have a daily import of all the product codes and relevent data that updates a smartsheet for me. I then use this smartsheet as a lookup table to retrieve core master data information like list price, weight, legal category etc. You can overwrite the whole file or update existing records, add new and choose whether to delete any or not.

    Hopefully this would give you what you needed. It is an add-on with a cost but we love and use it a lot, including updating dropdowns etc. to have a central place to maintain the values rather than search through all smartsheets to find where that field is used :)

    Good luck

    Sue Rogers

    AmerisourceBergen - MWI Animal Health

    Business Analyst

Trending in API & Developers