sia
My feedback
4 results found
-
10 votes
An error occurred while saving the comment sia
supported this idea
·
-
2 votessia
shared this idea
·
-
3 votessia
shared this idea
·
-
7 votessia
supported this idea
·
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