-
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…
-
Is there a way to grab attachments from a new line in smartsheet and merge it with the print file
Hi, I have been trying to work on a system that will automatically take attachments from a new line in smartsheet and be able to merge it into 1 pdf file with the print pdf of the smartsheet line. I have tried using power automate to computerize this process, but there is no option for me to grab attachments. I have…
-
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…