-
Deleting Columns using API and python
I have a column that is identical on hundreds of sheets. I am attempting to delete the column using python and the API. I am currently just trying to delete it from one sheet using a script as a proof of concept for all of the sheets that have it. The column in question is a date column with a column formula. My…
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Extracting data from a host server
Hi, I work with a developer and designed a website for an organisation. On this website people need to fill in a form and submit it. This gets uploaded on a data server where it is stored. The data can be exported as an excel file, but I was hoping that through an API Smartsheet can collect data directly. Is this possible…
-
Transfer ownership to another user using API.
We have requirement that we need to transfer ownership to another user using API. I didnt get any API for transferring ownership to another user. but i got one RemoveUser API. i tried with the api https://smartsheet.redoc.ly/tag/users#operation/remove-user But i got the below error while using the above api…
-
SmartSheet webhook -> Google Apps Script verification
Hello, I'm trying to set up Smartsheet's webhook listener using Google Apps Script, but having an issue with the verification step. My code looks as follows: function doPost(e) { var challenge = JSON.parse(e.postData.contents).challenge; var response = JSON.stringify({'smartsheetHookResponse':challenge}); return…
-
smartsheet.SheetResources.GetSheet(sheetId) Has no overloaded that takes 1 argument.
Hi All, I am using C# api for SS. I was exploring documentation code here: I can get sheet ID but when I try to get sheet itself, I run into build error that says SheetResources.GetSheet has no overload method that takes 1 argument i.e. SheetID only. Any ideas why this is happening or how can I rectify this?
-
Update Sight with API Error
I am trying to update a sight (dashboard) using the following code but am getting an error: The "Test Sight" object is working perfectly fine: But the error is coming from trying to use update_sight. This is a bit of a difficult ask but any help is appreciated!
-
Copy automations across sheets
It seems incredibly bizarre that automations cannot be copied across sheets - this is a huge pain at the enterprise level where permissions are sectioned by sheet ((i.e. Markets) but automations are needed for the global team. Creating every automation is a massive issue.
-
Smartsheet.gov app for iOS
Hello, Our program engineers use iPads in the field to conduct their site surveys using a FAA approved web-based site survey software. It would save them a lot of time if they could use Smartsheet.gov app on their iPads as well. Would it be possible to make the app available to iOS?
-
SmartSheet API to access summary report using python
I am using this code to access the summary reports but am getting this error. Any help would be great thank you!