Proton Sheets: Re-Order Conditional Formatting Rules
Allow users to re-order conditional formatting rules in Proton Sheets (Eg drag bottom rule up to the second top position.) This matters because rules apply on a hierarchical basis so top rules are applied before the bottom ones.
Bit Of A Tinkerer
shared this idea
-
sia
commented
Hello Proton Team,
I guess you have seen me so many times in this forum already, but I do hope this spreadsheet can become better.
The request to Conditional Formatting is about the rule. It is good to see that Proton Sheet's input field for rule is being able to extend, so that would be easier to read and write the complicated rule.
But here is problem that currently it doesn't support LET() function, here is an example:
The rule for my first tried was like this, and it just didn't work.
=LET(
x, $B3,
OR(
x="Hello",
x="123",
x="test",
x="umm"
)
)And then I started to prune the formula, and this one works.
=OR(
$B3="Hello",
$B3="123",
$B3="test",
$B3="umm"
)Well, although I learnt what's the limitation now, I still look forward to adding the support for LET() in Conditional Formatting.
Sincerely,
sia