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.

Sign in to vote!

Find more posts tagged with

On Radar

Comments

Arundhati

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.

Rick Olsen

Agreed, this can be a total pain to find the one or more rules that have to be removed.

Jake Gustafson

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.

D Gray

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.

Carson Penticuff

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.

Ketch Pablo

I encountered this today and would really love to see this feature implemented soon!

Caroline Dunnell

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.

SSFeatures

@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 ( https://ssfeatures.com ) 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!

SSFeatures

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 ( https://ssfeatures.com ) 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!

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…