Best Of

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.

@Andrée Starå Ok, thanks! You know what's odd? The formatting will show up in reports. Check it out. This is sourced from the same Project Sheet I shared above.