clone filters from one sheet to another

Hi,

I set up 5 filters in one sheet. I have 20 more sheets with the same columnar structure. I want to "clone" the 5 filters into all the 20 sheets. I don't want to do it manually. I don't want to do the "Save As New" because the 20 sheets have been established already.

How can I do it?

Thanks,

Shinya

Find more posts tagged with

Sheets

Comments

Paul Newcome

Unfortunately it is not possible. It will have to be done manually. It is a good idea though! Feel free to Submit a Product Enhancement Request.

Andrée Starå

Hi Shinya,

Yes, I agree with Paul, It's a great idea!

Also, it might be possible to use the Smartsheet API to automate it.

Is that an option?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Shinya

I did submit an enhancement request. Thanks for your feedback!

Sean

Andrée Starå

Excellent!

Happy to help!

Paul Newcome

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

How to prevent or recover deletion of rows
Is it possible to prevent the deletion of rows in a sheet? Specifically, in cases where a user legitimately requires editor permission to the underlying sheet and where the row cannot be locked (as continued editting of the row is required.) If not, what are some strategies for recovering a row that has been inadvertently…
Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…