-
Adding a row is throwing an Error 1018
Hi All, I'm new to Smartsheet API integration, when trying to invoke this API Getting below error { "refId": "b1abd0ba-49cb-4ea8-9944-", "errorCode": 1018, "message": "The value 'sheet id' was not valid for the parameter type 'long'."} Any guidance would be really helpful. Thanks, Junaid
-
Smartsheet login not working with email and code
Hi, I've observed that the new login feature, which involves receiving an email with a code, is not functioning in the Webview2 runtime (Smartsheet OAuth2) and Microsoft Edge browser. FYI: It works perfectly in Google Chrome. Here are the steps to reproduce the issue: 1. Open the Microsoft Edge browser. 2. Enter the…
-
SmartSheet API Report Source Sheet
Has anyone been able to access the source sheet of a report using the API? I am using Python.
-
custom button calling rest api
Hi, I have a smart sheet with ids and status. I want to call a rest api, send the IDs and get the current status of those ids. I have already written code which reads the ids list and gets the status and updates the status. All i need is some way to call this api from the sheet itself. Can i create a custom button, which…
-
Smartsheets Save Error
Hi, I am currently having a repeated error in saving the changes that I make to my smartsheet. It first occured when I was manually triggering an automation through a checkbox in a column to move to another sheet to house the filtered rows. I was able to move 26 rows by manually triggering each row, but on row 27 it showed…
-
How to create permanent API key after authenticate by OAuth2
From GUI smartsheet, I can generate an API key for Rest API. But I need to build an application that authenticate user by OAuth2, then can generate a permanent API key. In my context, there is an external application call the smartsheet API with the api key that is generated at time user authenticate via OAuth2.
-
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…
-
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
