Deleting columns in conditional formatting
Currently, deleting a column used in a conditional formatting condition requires you to go into the rule and manually remove the column. Would love to have SmartSheet prompt you to confirm you mean to delete, then remove those columns from the rule without having to manually update it.
Comments
-
Currently, I have to click on each conditional formatting rule and click disable or delete on a sheet. Major use for a check box type list so that I can either disable, delete, or modify multiple formatting rules together.
-
Agreed, this can be a total pain to find the one or more rules that have to be removed.
-
Agreed. Total pain. Could even pinpoint what rule to tend to. But certainly, would rather it delete the column and verify that you want to do what you're doing.
-
WE NEED THIS FEATURE!!! I have a lot of conditional formatting and we have evolved our sheet quite a bit so I wanted to delete columns but I don't want to delete the rules I have built or hunt for it in each rule.
-
I 100% agree. I have spent a great deal of time checking and rechecking multiple conditional format rules when attempting to delete a column. When you are working with a sheet with 30-50 rules, this can be extremely time consuming.
-
I encountered this today and would really love to see this feature implemented soon!
-
It would be handy to be able to delete multiple conditional formatting rules at once. I have 52 on a sheet I have copied from a template and I would find it much quicker to delete multiple at once.
-
@Ketch Pablo, @Carson Penticuff, @D Gray, @Jake Gustafson, @Rick Olsen, @Felipe Gastaldi
Hey everyone, my name is Nathan and I've been working full-time building a browser extension ( ) that adds more features into Smartsheet.
I recently added a feature into the extension that solves this problem.
If you have SSFeatures installed and you try to delete a column that is used by a conditional format, you'll see a big "Fix with SSFeatures" button. You can click this button to remove the column from all of your conditional formats.
Alternatively, you can access this feature from the SSFeatures menu.
This can save you a massive amount of time, compared to having to go through all of your conditional formats manually.
I hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
-
Hi @Caroline Dunnell and @Arundhati,
My name is Nathan and I'm working full-time to build a browser extension that adds more features into Smartsheet.
The browser extension is SSFeatures ( ) and it adds a button that lets you delete multiple rules at the same time.
This is a lot quicker than having to click and delete conditional formats one by one.
Best!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
