I would like to change the text color of public holidays on my app.
I tried to use "Format rules" feature and set the condition below.
IN([date] =
{"the list of public holidays"}
)
but an error message appeared, "Cannot compare Date with List in~" .
Anybody knows how to fix it or more smart way?
Solved! Go to Solution.
Review the syntax of the IN function. Replace =
with ,
.
Review the syntax of the IN function. Replace =
with ,
.
Thanks dbaum,
I made a silly mistake. That works correctly.
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |