Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
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…
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…
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.
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…
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…
📄 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,…
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…
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…
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…
It looks like you're new here. Sign in to post and engage.