Editing Conditional Formatting Rules

Hi,

Is there any way to edit the rules in conditional formatting? For example, if I have a rule that has 10 conditions, is there any way to go into the rule and delete one of the conditions?

Example:

If column 1 is 'yes' and column 2 is 'in the past' and column 3 is 'blank' and column 4 is 'not blank', and i wanted to change it to

If column 1 is 'yes' and column 2 is 'in the past' and column 4 is 'not blank', removing the column 3 rule.

The only thing it allows me to do is adjust the rule but not delete it. i.e. change it to 'not blank' from 'blank' or whatever.

Thanks for any insight.

Oscar

Find more posts tagged with

Conditional Formatting

Project Management

Comments

Pam Alakai

Hello Oscar,

Certainly! You can delete the specific criteria within the conditional formatting rule. To do that, Hover over the criteria, the criteria will be highlighted blue and the x icon will appear on the far right like in the screenshot below. Click on it to remove the criteria.

Kind Regards

Pam

Smartsheet Support

Screen Shot 2017-11-08 at 3.52.44 PM.png

StacyDe

This did not solve this question for me. I have a rule that has about 10 conditions. I want to completey remove one. Right now it's like "if column1 is unchecked, and column2 is unchecked, and column3 is unchecked apply this format..." I want to remove the check on column3. if I click on the condition I can then click on the "define custom criteria" link so I can see the "x" mentioned in the previous comment. However when I click the x to remove it then click ok I'm given a warning that I have to select at least one value for the condition. How do I just remove that whole condition?

glotzbach

Same issue here. I cannot delete a condition, only add. Seems we're forced to delete the rule and re-add conditions to make a simple change to the rule.

hanseric

Yes, exactly! I have the same precise problem. I have an "and" condition in my Conditional Formatting and I just want to remove that one condition.

It's looking like the rule might have to be recreated from scratch, is that right?

arkitektur

the same with me - please provide the delete function so we dont have to start from scratch, thx

tdladmin92356

Two years later, I'm still having this problem. Is it entirely impossible to delete a single condition from a rule without remaking the entire rule from scratch? Did someone genuinely think that was a good idea? Having thought that, did someone genuinely not think it might be a good idea to work on that at any point in the last two years?

Shawn Connelly

Same issue here. I'm guessing there's no solution since no one from Smartsheet is responding to this thread and we'll just have to submit an enhancement request.