Cant get a format rule to work

[TJK]

I have format rules in place that are working fine to color pins on a map. I am trying to do another format rule which is exactly the same but just reads from a different column and this one won't work for me.

I have it at the top of the rules list, and I have just copied another rule and changed the formula to include the new source column.

The circled pins on the map shown should be pink..

I can't figure out what I'm doing wrong

Cheers

Troy

[dbaum]

If you didn't already, confirm (e.g., using the test feature in the expression assistant) that your expression indeed evaluates to true for the intended rows. For example, if [Scoped] is not a Yes/No type column but rather a Text type column then your expression would need to be [Scoped] = "TRUE" (i.e., with quotes).

[TJK]

Thanks so much for the quick reply dbaum!
I have the SCOPED set for Yes/No, but still not working.
Do you have any other suggestions?

[TJK]

It is exactly the same as [complete] which works fine???

[dbaum · Accepted solution]

Additional details to check in troubleshooting:

• If you didn't already, confirm you selected the color using the same property in both rules--i.e., either "Highlight color" (which is the property that I think is applicable to map pins) or "Text color".
• Confirm the rules are sequenced to achieve the effect you want. Per Format Rules: The Essentials - AppSheet Help "The rules are processed in order from the first to the last. If two matching rules conflict in their formatting information, the last rule takes precedence. "

[TJK]

AHA!
I had it at the top of the list. I put it down the bottom (last) and that fixed it.

Thank you so much mate!