Apply a rule to multiple sheets

I have 75+ sheets that represent properties where my company does cabinet installation work. I am wanting to create rules and apply them to all the sheets at one time.

As of right now, I have to re-create the rule 75 x's.

Is there a way to create the rule once and apply it to all my sheets?

Thanks for your help.

Find more posts tagged with

IT & Operations

Comments

Andrée Starå

Hi Steve,

Unfortunately, it's not possible natively but maybe thru the API or Control Center.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike L.

This would be a worthy product enhancement request IMO. I started by importing 36 sheets of data then had to go back to format (bold, alignment), correct column data types (sometimes things randomly import as dropdown), add conditional formatting rules, supplemental data columns. It's not a problem when I import 5 new sheets a month to format them all but going back is frustrating. It would be very convenient to be able to add a rule or column to a group of files at the same time.

steve50951

totally agree. it's been super frustrating and time consuming.

Maybe they'll figure it out.

SGF

J. Craig Williams

API:

- can not create an automation rule.

- it can update one, but I have not tested new behavior since the release 2018-10-02. The behavior prior was not complete, so I doubt they fixed it.

- I have started to try to create new sheets ONLY from my own templates and each template has at least one Alert (I'm thinking that is not enough) so that if the API improves this will be something I can take advantage of.

- can not create, modify, or delete conditional formatting. In some cases, it allows reverse engineering by determining which conditional formatting effects which rows, but that is pretty much a dead-end.

- the rest I think it can do

....

If you don't care about things like these on the targets sheets:

- additional conditional formatting

- any user defined filters

- cell history

The API could be used to bring a set of sheets up to the standards in the master.

Is there a demand for it?

Craig

Mike L.

Not sure I follow (smartsheet newbie here), what is the purpose of the alert? (thanks!)

Suzanne Raphael

Sure would be great to be able to apply conditional formatting and/or formulas across sheets.

Sign in to join the conversation!

Quick Links

Trending discussions

I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…