-
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…
-
Column freezing via API
Is it possible to set certain columns as 'frozen' via the API, or Python SDK? Having trouble finding any documentation on this. This is going to be used for many API generated 'schedule' type tables, and would be very nice to set without going through each sheet's UI. Thanks!
-
Clear cell of hyperlinks after inserting values by API
Hi, this is probably a really obvious issue, but I know just enough to be dangerous. Here’s the situation: I am using a Zapier custom webhook to insert a value and URL into a sheet cell to create a hyperlinked cell. So far so good. It all works fine. However, I cannot overwrite that cell with non-hyperlinked data once this…
-
Smartsheet app authorization - allow access
Greetings, Looking for a guidance. As I am developing an application, that updates data to a sheet periodically (every month). Here, when I send a GET request to https://app.smartsheet.com/b/authorize, with all required parameters, its redirecting to my app's consent page where I have to click on 'Allow' button to proceed…
