Product questions?
Ask it here! The community's got your back.

API & Developers

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

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.
Report Builder
Hi Are there any written instructions I can refer to in order to create a smart sheet report that I can then build into a chart? I have tried to create a chart from a dashboard widget and I am getting an error telling me I can only use numeric data Is this correct? Thanks Tracey
Children not displayed
I have a list of that will not open up today. There are 671 children and the "+" and "-" changes but the rows are not displayed. Help please! Rose
Open to Today's Date - shift a little to the right?
This is a small request - how about modifying the setting of opening the Gantt window to today's date so that it appears an inch or so to the right, rather than nestling at the edge, kind of out of sight? It would help give added perspective on tasks completed/partially/not completed by being able to see both sides of…
Webhooks API
Hello, Does anyone have any good examples of using the webhooks feature of the API to send notifications to Slack? I'm not sure if I have everything structured correctly in Smartsheet but, essentially whenever a certain cell in a sheet (that could live in a specific set of Workspaces), I would like to have a slack…

Trending in API & Developers

Smartsheet API - Is it possible to create a copy of a sheet and maintain the row and column IDs?
Is it possible to use the Smartsheet API to create a new sheet from a copy of an existing sheet, but maintain the row and column IDs? Ideally the output would be 2 sheets with unique IDs, but the row and columns within each would have identical IDs
How can I obtain the URL for a form that is attached to a sheet ?
I need to obtain the FORM URL that is associated with a sheet that is copied via API so that I can populate the URL in a cell. I was reading over the API documentation and cannot seem to find where this is possible. I know this has been asked sporadically and apologies for the duplicate asks, but this seems like such a key…
Order of the Columns
Hi everyone, I didn't find this answered anywhere, but is it possible to change the order of the columns using the API/SDK? I have a large number of sheets that I want/need to keep separated but I would like to standardize them with a defined order of the columns. Is it possible to get an attribute like "column order" and…

API & Developers

Categories

Popular Tags

API & Developers

Discussion List

Categories

Popular Tags