-
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
-
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…
