-
Script becomes unresponsive after deleting 10Krows.
I am attempting to delete rows from a Smartsheet that contains 16K rows. I'm using the smartsheet_client.Sheets.delete_rows(sheet_id, rows_in_chunks) method and have tried deleting in chunks of 20 and 200 rows at a time. However, the script becomes unresponsive/gets stuck after deleting 10K rows. I'm wondering if this…
-
How to create a countif formula with OR
I am trying to create a formula across columns with different values in a cell. I have the formula for one value, Preliminary Draft. This works fine. =COUNTIFS({Comments Log Range 1}, [Document Name]@row, {Comments Log Range 2}, "Preliminary Draft", {Comments Log Range 4}, "Open") However, the value in range 2 can also be…
-
Upload in Batch Python API?
Is there any way of uploading data into Smartsheet in batches? Still fairly new playing around with Python and Smartsheet's API. The full script have works, its just I have 10000+ rows I want to upload. The script below is what I use to delete the information from the sheet in batches. # Get the rows from the sheet sheet =…
-
Issue When importing an EXCEL file with API ? (switched indent !!)
Hi all, I have a question about what seems to be an issue in smartsheet API. I am surprised not to have found this bug in the forums because the Excel import in smartsheet must be very used? Here is the issue : When you import an Excel file containing indentation, with this script : https://smartsheet.redoc.ly/tag/import/…
-
Spontaneous generation of new sheets
Smartsheet issue with spontaneous generation of new sheets. 1 - We created a self-test on our company websites. 2 - Once the test form is created it is directly integrated with Smartsheet. 3 - Once the integration is connected, we completed a sample submission, and the repository is generated. 4 - Once the repository is…
-
Issue with Syncing Smartsheets to Outlook
How do I format the time columns/add proper formulas to get the calendar to sync to outlook with the times included? Right now showing as all day event (see right calendar)
-
Quotes within a formula for API PUT/POST
How is the data supposed to be formatted when a formula has quotes within it such as =IF(X=1,"One,"") ? I am getting just slashes in place of the quotes when I export a formula using the API, but when I use the same syntax to add/update a column with a formula it doesn't parse correctly. I tried /" and double-quotes.…
-
SmartSheetAPI PUT
Hello, I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman: PUT Request URL: https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId} Request Body (JSON): { "value": "test", "displayValue": "test" } However, I'm…
-
Python SDK API to add rows with Multi Columns to Smartsheet
I have a script that reads columns from my source Smartsheet (SS) and gets the values from the columns in the SS and stores them in variables. This code works. Where I am getting stuck is assigning the variables (2 or more columns) to a new row and then adding the row to the destination SS. For example: Source SS, reads…
-
How to programmatically erase a date column cell, with project settings and dependencies enabled?
Hi everyone! Need your help! I'm currently facing a challenge while attempting to programmatically erase a date column cell, with project settings and dependencies enabled. I am able to change the date, but not able to erase the existing date. I can successfully delete the column value manually, but I'm not able to achieve…
