❓️Product questions
Sign in and ask it here! The community's got your back.

📈 Wondering if there’s a problem?
Check out the Status Page and subscribe for notifications.

💡 Share your knowledge!
Help others by answering questions.

API & Developers

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

Are webhooks a premium feature in Smartsheet?
Hi All, I'm in the process of building an app that utilizes Smartsheet's API and I would like the code to run whenever a change is made to a particular sheet. In the API's documentation, it appears that "Event Reporting" and Webhooks are my two best options. However, Event Reporting is a premium feature that is not…
Sum cell from last row - multiple sheets
Hello. Looking to sum a specific cells from multiple sheets. Have 5 sheets. Columns are the same across all five sheets. Looking to take the last entry, say for column 1, across all five sheets and sum those values. That value would live in another sheet. Any ideas? Thanks Shawn
Smartsheet Live Data Connector ODBC issue with SSIS package
Greetings, I installed and configured both the 32 and 64 bit of the Live Data Connector on my machine and created a SSIS package to read from a Smartsheet and write to a SQL Server table. The ODBC connection is made via an access token and my own credentials (we use SSO to log in). From my local machine, the package runs…
Backup tool for one user only?
I am using the backup tool provided through the below link with SmartSheet. The issue we are running into is that we do not need it to backup every single user (this is time consuming and bloats to over 3 gigs of data currently). We are looking to keep this more targeted if at all possible. Has anyone had any luck altering…
Conditions only flow to the first on the left
I set after first approval process, it will seek a 2nd level approval base on 4 conditions to 4 different approval. but the flow do not move if the 2nd, 3rd, or 4th conditions is met. It only work when the 1st condition is met. please help
Failed to send a single value to a multi-select dropdown column
Hi, I have a multi-select dropdown column on my Smartsheet, I am trying to send a row from Excel to Smartsheet. Let me make an example, I have two salespeople John and David working on this project called test123, after salespeople finished entering on local Excel, they need to send entire row to Smartsheet, however it…
Hide details in a sheet
I am working on a sheet which contain multiple country wise data. i will share sheet to all country wise reviewer to update information.. i want to hide sheet data and show only respected country data to end user.. how's is possible.??
search api doesn't pull up partial matches or numeric search
Hi, I'm using smartsheet integrations and use search API to get the queried sheet name. https://api.smartsheet.com/2.0/search?query=myquery&scopes=sheetNames Example: Assume that these are the sheetnames I have created a sheet a ac sheet ac sheet account sheet account10 These are the issues When I query "a", it returns…
It's possible to create clone sheet of my main sheet.
i want to create 2 dynamic sheets based on same input. but some columns might be visible. so i will create separate view or any clone / copy paste options are available.
Update all rows with dependency defined (Duration and Predecessors)
In Smartsheets I have these columns Duration, Predecessors, Start and End Date, When I change my base Start date all my rows for EndDate and StartDate are then populated. I am trying to achieve the same functionality by api but when I update that base cell with start date value it gets updated but not the other rows for…

Trending in API & Developers

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,
Do you know if you can add a custom code in values (pink rectangle) - Bridge Workflow?
Do you know if you can add a custom code in values (pink rectangle) in this Bridge workflow that is updating a SharePoint list any time changes are being made in the relevant Smartsheet Table? Basically this workflow is working as expected with one issue: for every empty cell, the workflow will update SharePoint with the…
Number values containing 'Apostrophe after being imported from Excel
Greetings All ! looking for some assistance regarding an integration issue I've picked up when importing data from Excel to Smartsheet's using MS FLow , i.e. Excel->MS Flow-> Smartsheet I am inserting an integer but the value on Smartsheet contains an apostrophe before the number which is not ideal as i am using these…

API & Developers

Categories

Popular Tags

API & Developers

Discussion List

Categories

Popular Tags