-
Getting Blank Rows While Inserting Data directly using Python
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…
-
How to bulk create cross sheet references using Python and Smartsheet API
Hello, This post provides a solution for quickly adding cross sheet references to a large number of sheets. The cross sheet reference refers to a single column. Caution The API code can update any sheet where you have permission to create cross sheet references. There is no way to automatically remove or edit cross sheet…
-
Smartsheet Python API clear images from a range of cells
i'm currently using smartsheet python API and have managed to create a script that from a given range of rows (for example row 4 to row 20), for the 10 first columns, it deletes all the contents. It is working perfectly, however it only deletes all the string contents, but the images still remain. the images were attached…
-
API Issue with list_sheets
I script in python. I need to explain some things about how we use Smartsheet. We have a master sheet that has all of our current orders on it. We have around 200 projects, and each project has its own project sheet. When an order is placed via update request, a daily script picks up the info and creates the order on the…
-
Delete all available time entries in Resource management
Hi Team , I'm looking for a way where I can fetch and delete all available time entries from Resource Management preferable programmatically using python. If not I'd like to know more if there an option to do that in a different way which can help delete all time entries in one simple way.
-
How do I programmatically update Start Date, End Date, Duration and Allocation %?
Hello everyone, I am working with the python smartsheet SDK, and I am experimenting with a smartsheet connected to Resource Management, which comes with a number of default columns - few of them are Start Date, End Date, Duration and Allocation %. I see in the Python API documentation that these 4 columns are not allowed…
-
Archiving Final PDF documents outside of Smartsheet through a script in Python
📄 Automating PDF Downloads from Smartsheet Reports Hi everyone, I manage hundreds of documents generated across multiple sheets in Smartsheet. To keep things organized, I use reports to consolidate them — but I often get asked to ensure these documents are also backed up in SharePoint for redundancy. Unfortunately,…
-
unable to move a row in Python
I use Smartsheet to govern a project that does ~10k tasks per year so automating as much of the project is extremely helpful. I have multiple python scripts that are updating sheets and grabbing data form sheets but this is the first time i have tried to move data in a sheet. I am trying to move a row below another row…
-
Problems using Python API and Cell History - note returning all user input.
I have been using the cell history to try and grab user input. The Input comes from users typing or selecting from a drop down. The data shows fine in Smartsheets. Dates are auto added but text e.g. "11k Production process complete" is user input when using the report/sheet in Smartsheets. But then when I use this code to…
-
Is it possible to test code in a Sandbox, and not in the Smartsheet Production Environment?
I am VERY new to API's, Python, and Bridge. I'd like to test my scripts on our existing Smartsheet Data, but without the risk of breaking something in our Smartsheet Production environment. Besides me making mistakes, to run test scripts in our environment on production data, I need a change request and multiple meetings…