Best Of

@Dale Murphy

Below is a manual workaround I use to get a notification when a sheet is getting full.

In the Sheet Summary of the “trash” sheet, I have 3 fields, Total Columns, Total Rows and Total Cells (which is Total Columns*Total Rows). On the first row of the sheet, I add an INFO row with specific data that I can reference in automation and the Total Cells (=[Total Cells]#) in another cell. (I color that row orange.)

This allows me to setup automation that runs Every Day at a specific time and sends me a notice when the Total Cells is >350000. I manually delete all the rows because we don’t need them, but I don’t have to think about it until I get notified. 

On my notification row, I’m using the cells that are in the sheet – I didn’t create any extra columns:

I know its not automated, but perhaps it will help you.

It can take a while to delete so I usually open it in a new window and let it do its thing while I move on.

Some folks want to keep everything - in that case I make a copy of my Move sheet for posterity and then delete the data.

Hi @smartsheetwilly

Thank you for confirming that you see the desired sheet!

Yes, the sheet picker was updated recently. The pop-up window is a window to Search in, versus immediately displaying sheets in your account. Here's the release note:

Cheers,

Genevieve

I'm new to the Smartsheet Planning group for our team so I'm coming in after years of them doing things a certain way. I'm trying to find a more efficient manner to manage updates to master sheets instead of rolling them out quarterly as we've been doing. Essentially every quarter we pull all feedback, make updates to the primary sheets we have, then the team uses the new version for any new projects going forward. This doesn't seem like the most efficient way to do this.

Right now we make multiple copies of a particular sheet and team members rename one of the copies for their project. The problem with this is if we find an error or an update we'd like to make to the master as we are working through our project, we can't push out updates to all sheets that are already being used. This means everyone is not potentially using the same version of the sheet.

I'm wondering if there is a way that if we need to make updates to the main sheet is there a way to get those updates to flow to all sheets being used. Would creating a template and people creating a sheet using the template work like this? Essentially making the sheets being used dynamic and up to date with all corrections/updates to the master template.

To automatically delete rows in an "archive/trash bin" sheet I do this. I use a standard "move" automation template to move the rows into a newly created "trash bin" sheet. Using Data Shuttle I do this:

1. Create an Upload workflow.
2. The source file will be a blank .xls or .csv with the identical structure as your regular data import file - but blanked out, no data.
3. Configure the workflow for complete replace of the target sheet (the "delete bin" sheet).
4. Schedule the new delete bin workflow frequency greater than the frequency of your data import. For example, if you upload your data every hour, then empty the trash bin every 15 or 30 minutes. I do this to reduce the chance that I could "overflow" the trash bin and halt the automation.

Actually, we found the solution!

embed the image and then look up the slide ID.

As long as the image (file) and slide ID are included, it will always open up to the same slide every time.