I am trying to create a format rule for a data table I have, and the column has both "FALSE' and "TRUE" in it. The datatype in AppSheets is "Yes/No". I am trying to format a row in my return UX so that if it is TRUE, then the row is highlighted. I've tried a few variations but nothing seems to work. My latest was:
[Awards Show]=true
Here is what it looks like. The columns with '$$' in the upper right are the ones that should have a yellow highlight to them.
Solved! Go to Solution.
For a Yes/No column, all binary values are interchangeable - TRUE, true, y, yes are all equal. Same for FALSE, false, n, no. So pick one style and stick with that.
In your Format Rule:
Did you set a column to be formatted in the "Format these columns and actions" section?
There are two color options when formatting. "Highlight" and "Text".
If you have applied the settings as described above then it should work.
Here are my $0.02:
I use logic instead of words when it comes to Yes/No. For example, since 0=0 is true, I would use that instead of Yes, True, Y, etc.
Also, since you are trying to use a Yes/No column on your expression, with the column itself is enough. [Awards Show] is already a Yes/No so you don't need to add any other thing.
It seems like you are not doing what @WillowMobileSys said. You have to select wich columns you need to be formated on the Format these columns and actions section.
Your ID is terrible. I'm not blamming you, just change that. Sequential ID's are not a good idea, you should stick to the UNIQUEID() function
https://help.appsheet.com/en/articles/1023086-what-is-a-key
https://help.appsheet.com/en/articles/2357317-uniqueid
User | Count |
---|---|
25 | |
15 | |
4 | |
3 | |
3 |