-
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
-
Multi-picklist using a list of element "errorCode": 5536
I'm trying to implement a multi_picklist with a list of elements, the following code works with one element but fail with a second one, so I think the structure is good, but the format of my list maybe wrong or I'm missing something def listToString(s): str1 = "" for e in s: str1 += e print(str1) return str1…
-
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…
-
API Question
I'm trying to get a list of all the shares for a sheet. This would include all the item shares(someone shared this specific sheet) and the workspace shares (someone can access the sheet because the workspace was shared. According to the API documentation this call should do it: curl --silent…
-
When I scan a barcode using a form, an extra ' is entered before the number.
I´m using the barcode scan function in a form to enter the barcode. However, when I do the scan an extra character , ', is entered in front of the number. So instead of the number 10345470605 being entered, '10345470605 is entered instead. This is creating errors when I later do an INDEX/MATCH. How can I get rid of this…
