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

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
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…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.