-
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/
-
When a sheet is deleted, are any webhooks associated with that sheet deleted or disabled?
Hello. Imagine you have created a sheet, and used the webhook API to designate a webhook about that sheet, and enabled that webhook. QUESTIONS: If you delete the sheet, are you guaranteed a webhook event for a deleted sheet? And if so, how would you know the event was about the sheet deletion? Is the webhook associated…
-
Is there a way to remove a contact from all notifications at one time?
I have several sheets with hundreds of notifications and need to remove one contact from many notifications. Can the contact be removed from all the notifications at once? I have already transferred ownership of the sheets and deleted the contact from the account. How do I remove the contact from the notifications without…