Product questions?
Sign in and 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.

Why did you break your API documentation?
it used to be top notch and extremely easy to use, now its a pain most of the important info is hidden! I mean for instance if you don't know where in the documentation to look for say update-cell syntax - you cant use the search to find it! If I am wrong what query string do you have to enter into the search to find the…
Smartsheet URL and Redirect URL for connection with Celonis
Hello together, i am trying to connect Smartsheet with Celonis. I already have a Client ID and Client Secret but everytime I try to connect both, Smartsheets shows an error saying Redirect URI ist missing or wrong. Does anyone know what to fill out in the Developer Settings of Smartsheets in the field APP URL & APP…
Custom object for expenses (SmartSheet Resource Management)
Hello! I've been asked to create a way to easily parse out expenses into project versus pass through. Is there a way to do this without creating duplicate categories (i.e., "Pass through_expense category 1" and "Project_expense category 1"). I've created custom objects in other PPM software and not sure if that's possible…
How to guarantee proper results on "GetSheet" API after "UpdateSheet" API"?
Imagine a gantt-style Project sheet with many tasks on it. That sheet was created with a particular work schedule (days of week, and hours per day) and a particular holiday schedule. Now use the UpdateSheet API call to update the sheet and change the work schedule and/or holiday schedule. This will cause cascading changes…
Where is the best place to find help with Power Automate Integration
I happen to be the power automate guru for my team, which isn't saying much. Problem I'm trying to solve: when a cell updates (based on certain target columns), extract that info to a SharePoint list (or some other repository). Why? We have several different project tracking systems and want to consolidate info into one…
.net 6?
Hi, Any estimate on .net 6 for the api? Issue seems to be RestSharp and its last major update. Your code when pushed to new AWS .net 6 runtime fails: Void RestSharp.RestClient.set_FollowRedirects(Boolean) at SmartsheetBuilder().SetAccessToken(apiToken).Build() We are using smartsheet-csharp-sdk @ 2.126.0 Many thanks, Brian
Url links for attachements
Hello, My Ict department blocked out all website except for the tools we use On the tablets we want to view .jpg and .pdf files As far as i know they are stored on com.smartsheet.android.file/attachments or s3.amazonaws.com ? we gave both urls premissions to beeing viewed but still it says Links of content are blocked,…
Is there a maximum length for a Webhook Shared Secret?
Smartsheet will randomly generate a Shared Secret to use to check signatures on Webhooks to authenticate them. I will need to store that shared secret in a database. I need to know the maximum length that this Shared Secret could be. What is it? Thanks.
smartsheet api: how to read a certain cells value from google apps script
Hi all, could someone please help me how to read a certain cells value from google apps script? I have token, sheet id, col id and row id, but do not know how to do the code. Thank you, Joachim
Formula needed to show project week
Hi all, I'm trying to put a project week column in my timeline, and I need it to return the actual project week and not the calendar week when looking at the start to finish date. Example: If my project started on 31/10 this will be week 1. The formula looks at the task start and finish date and returns - 1,2,3. This is…

Trending in API & Developers

Change Agent with Python SDK is not working
Hi, I'm using smartsheet-python-sdk version 3.0.2 with Python 3.11 and trying to set the Change Agent so I can use it to read when receiving the webhooks but although I pass the change_agent parameter this is not being applied. When i made the request using cURL it works fine. The below is how I set the change_agent:…
SmartSheet API call via Alteryx
Hello, I have recently built an Alteryx model to extract data from various smartsheets that I have access to. While the model does what it needs to do, the API call seems to work only on a random selection smartsheet IDs. As a first step, I am extracting the details of the smartsheets that I am given access to (just the…
Bridge: Move select columns/attachments/comments to another sheet
Hello all! I'm looking to see if a Bridge workflow can be done with moving/copying select columns from one sheet to another BUT also bringing their attachments/comments over as well. I've made a workflow to copy select columns from a source sheet to a targeted sheet but never have the comments/attachment follow. I have a…

API & Developers

Categories

Popular Tags

API & Developers

Discussion List

Categories

Popular Tags