-
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…
-
Report Question
Greetings, I am sure this is a no brainer question and I did try a search. Also, I am rusty, it's been awhile, apologies. In a row report, I am pulling data from the "Mother of all Sheets" were everything is stored. We interact with this sheet using extreme care. In my Row report, I can can sort and group moving where the…
-
Locating Unique ID of Group
Hi, I am trying to create some flows using Power automate to auto-add members to a group. However, I am having trouble locating the "unique ID of the group". Can anyone advise me of where I can locate the group ID? Thanks.
-
Get values from a custom column
Hi All. ¿Can we get values from a custom or native SmartSheet column using the API? Or there are limits or restriction? Please ¿Can you share me the link where the API limits are documented? We have a requeriment to get values from a custom column using functions implemented on Google Cloud. Thanks in advance
