Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Feature Request - Auto format for ranges
It would be extremely convenient if we could set our autoformatting rules for a Row, a range, or even the whole sheet, instead of just one column at a time as is the current configuration.
I have 15 columns that I would like to apply the same 6 formatting rules to. Currently, that means that I have to define 90 individual rules in the conditional formatting toolbar!!! That is extremely heavy.
If I could set a range of cells in the autoformatting toolbar to apply the rules to, then this would mean that I only have to define 6 individual rules. That would reduce the load by a factor of 15x!!
It would also be good if we could clone a group of rules at the same time. Currently, you can only clone one rule at a time. Based on current functionality, if I have the same 6 rules for all 15 columns, then I have to do the clone process 85 times.
Please look into this and decrease the undue workload needed for those of us who use conditional formatting on our sheets... which I think is a great deal of the SS populace.
UPDATE - Having 90+ conditional rules applied to your sheet really slows it down as well
UPDATE - I had to delete 60% of the rows in my sheet because they slowed the system down too much. I have 25 columns by 350 rows with 90 rules and several formulas. Zero links. It is still really slow to load. It takes it an average of 10seconds for the screen to catch up with all of the formatting rules. Really wish I knew a method to speed them up, even if it's just reordering the rules. If I knew they were applied in a certain order, then I could arrange them in that order.