-
Identifying paid user accounts via the API
Until recently it's been possible to identify licensed, paid users via the API looking at the licensedSheetCreator attribute. However, with the recent changes to Resource Viewers it seems that it is possible for the API to return users who are non-billable resource viewers with licensedSheetCreator: true . This is leading…
-
Unable to input external data to SmartSheet through API
Hi community members, I'm working on a project to fetch our students' quiz score data from Blackboard, an education platform, and send it to Smartsheet using the API. I've successfully retrieved the data from Blackboard and prepared it for transfer to Smartsheet, ensuring the data is correct and the column IDs match those…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
-
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: https://github.com/smartsheet/smartsheet-csharp-sdk 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…
-
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!