-
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…
-
Is there a way to create Folder and Sheets using C# SDK
Hi, I have built a custom form in the portal using C# and would like to create a folder & sheets in Smartsheet using C# SDK How can I achieve this? Is there a way? Thank you Joseph - Copernics Consulting | congruent Global https://copernicusworld.com/ | https://congruentglobal.com/