-
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…
-
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/…
-
How can I tell where the automation email fail is coming from?
My IT Dept. says Smartsheets is whitelisted. They show no record of any emails getting blocked. However, my automation is to send an email when a row is added from a form and now no emails are going out to anyone. I even tried Run Now and nothing is going out. Is it Smartsheets? Is it down? It worked two weeks ago when we…
-
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 =…
-
Using Smartsheet as chat hub
Hi community. I am developing an app through SS API and am looking to connect chat channels like WhatsApp, Facebook, SMS, etc to Smartsheet. Each row represents a customer and ideally, we want all chats with this customer from all popular apps to populate into the conversation section of SS. Is this possible? If not, we…
-
Sample cURL throwing errors
Hello All, I am looking to use cURL for some basic API updates to my sheets. I have used it successfully to pull down data for columns/summary sections, but when I try using the sample cURL to add a field (after updating the cURL for my sheetID and APIkey), it throws errors. Any idea why this might be happening. Wondering…
-
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…
-
Persistent permalinks
I have an issue where my permalinks become useless after midnight. I create a bunch of permalinks to the rows in my main sheet. At midnight I move all these rows to an "Archive" sheet. Is there a way for the permalinks to reference the row that has been moved? Anyone else have this need? I had thought about renaming the…
-
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.…
-
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)
