-
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!
-
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…
-
Apostrophe ' is added before the number
Hi All, i got an issue with one of my column -column 1 - '235245 The number is automatically populated via API but its adds an apostrophe ' before the number. This is a primary number so i can't change the column type to text and again convert it to a number.
-
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…
-
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
-
How do I automate Smartsheet API "get_sheet" function to go through a list of sheets and save data?
Hi, I'm currently creating a catalogue of all sheets in a workspace using the "get_sheet" function. The data I'm collecting (crossSheetReferences, cellLinkIn, LinksOut) can only be found within the "get_sheet" function. I have a list of sheet ID's (sheet_list) that I use for collecting data. My code (python) looks like…
-
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…
-
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.
-
Push Row with Attachment
Hallo, I create integration from my form on the website to connect to Smartsheet using API. I want to push data with attachment in one time process, it's that possible? Thanks,
