API & Developers

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

Product Key
I need my product Key for run powershell command. Where I can find them?
Pull attachment from Sheet
Is it possible to create a form that pulls attachments and sends back to the requester? e.g., I have a sheet completely filled with a column titled "Common Number Criteria", and an attachment that corresponds to each number in the column. If I created a form and send that link url to an outside user, can they type the…
email data from smartsheet nice visuals
Hello, we are looking for a nice visual way to email data from smartsheet to clients regularly, without having to take screenshots or do anything manually. any ideas of how to do this within an email body? Ideally we would love to email a dashboard but this doesn't seem possible
Smartsheet/JIRA Connector: Putting tickets into their sprints instead of in the backlog
We have set up a connection between Smartsheet and JIRA and whenever a row on our Smartsheet becomes a ticket in JIRA, it automatically populates in the backlog instead of within the sprint we've defined within Smartsheet. Is there a way to get around this? I saw a thread that I think was related to this which mentioned…
IF Statement for a whole row
Hello! I'm trying to use this if statement: =IF(OR([1]67:[30]67 = "R13"), "500", "") But it's not working when I want it to check the whole row ([1]67 through [30]67) for R13. Is there another way for me to do this statement? Thank you!!!
Issues connecting to Smartsheets
Hello, Other areas of the business are exploring the use of smartsheet and they would like to connect our existing analytics tool (spotfire) to use smartsheet as a data source. I've followed: http://smartsheet-platform.github.io/odbc-docs/ and successfully installed the ODBC smartsheet driver, created a DSN, successfully…
Data Tracker producing duplicates
Data tracker is producing duplicates in my master task sheet. Even if I call the same source file duplicates are being generated. Anybody else experiencing this problem? Portion of JSON file: "testingnew": { "sheetId": "1172822425921412", "src": { "sourceId": "TESTINGNEW", "fileName": "./data/TESTINGNEW.txt", "delimiter":…
Google Forms sync - access denied
Hi, i have enabled Google forms sync for Smartsheets, when I click the add-on for smart sheets in a form and it tries to connect to SS, I get this error: Smartsheet Sync: Has been denied access to your data. any help on what is going on here?
User Email to update status in smartsheet
Dear Smartsheet users, can I use an email to update a status? We create a ticket in Smartsheet - then we send it to a ticket system. A status update will be provided back to smartsheet and should update the status from new to done. All I found was just creating a new entry in a sheet upon email entry. Regards, Christian
Connector between Smartsheet and Google Docs
Hello, I need to connect Google Excel (Google Drive) to Smartsheet so that I can have updated data on Smartsheet. I need to know what is the best solution.

Popular Tags

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

Internal Server Error w/ API PowerBI connection
I am running into an error when connecting Smartsheet to Power BI (Power Query). I am trying to refresh my PBIX file, but I run into the following error when trying to connect my Smartsheets: The issue randomly started today. No new data and/or transformations have been used on the existing data.
Summary field with formula by API
Hello everyone, I have a function that I run via API that helps me replicate improvements across all the spreadsheets for projects I work on. I tried to insert a new formula field into my spreadsheet using this function and it worked perfectly. However, the field results in a formula error and I need to access all the…
VBA to Smartsheet
Hello all, I am relatively familiar with Smartsheet and VBA. From my understanding I will need to API access to achieve this, but am I able to write a VBA script that pulls my excel file into a Smartsheet report? Just wanting to know for sure if that's possible. Thanks!

API & Developers

Discussion List

Categories

Popular Tags