Conditional Formatting doesn't want to update

Suggestion Box Bugs
1

Hi there :grin: !

I think I kind of hit a bug (or at least something not that logical) with the new conditional formatting of a table.

In my table I use a select list to create some rules of conditional formatting :slight_smile:

I decided to change one of the selectable items Could be useful and simply replace it by Useful and then went to change the rule I previously created because the rule didnā€™t get this new value. (Which is normal)

I didnā€™t used the formula to create the rule, I just checked the checkboxes in the menu filtering by is any of but I wasnā€™t able to modify the rule that way even though the new value was there.

Conditional%20Formatting
Conditional Formatting.gif816Ɨ594 2.31 MB

I had to go through the formula ā€œpre-createdā€ (as Coda wrote it for me) by the ā€œnon-formulaā€ rule and modify it there.

26
Capture dā€™eĢcran 2019-10-24 aĢ€ 13.47.26.png1134Ɨ366 22.7 KB

No big deal :wink: as I was able to make this work :wink: but I donā€™t see any logical reason for why I simply couldnā€™t update that rule without going through the formula :thinking: .

PS: Iā€™ve tested this on the lasted version of Chrome (78.0.3904.70) and Safari with the same results

2

Can confirm. Experienced this a few weeks ago. The new conditional formatting UI does not register changed values. The user must access the custom formula to reference the updated value.

2 Likes
3

@Ander Thank you for the confirmation :grin: ! Iā€™m not feeling alone anymore :wink: !

Well this tiny bug get a little bit in the way of having conditional formatting without formula, as the whole point was to not having to go through formula :confused: (even though itā€™s still not a big deal :slight_smile: )

1 Like
4

Sorry for this issue. Itā€™s a scenario we plan on supporting. For now the best workaround is to go edit the clause in the formula editor. Weā€™ll come up with a fix soon to ensure that no-one needs to go to the formula editor to fix - after all the purpose of this feature is to minimize that! Thanks for the report.

2 Likes
5

Hi @Matthew_Tebbs :blush: ! Thank you for clarifying this :blush: !

It never crossed my mind that this scenario wasnā€™t implemented yet in the ā€œnew conditional formatting without formulasā€ :wink: .
It might be a little bit confusing though, especially for new users :wink: .
But like I said, itā€™s no big deal as the workaround is pretty obvious :wink: .

But Iā€™m really glad to know that this scenario (ā€œbeing able to modify a rule without having to go through the formulaā€) is somewhere on the roadmap :wink: .