Filters "contains" does not work

Hello,

I have the most simple table that contains team members, and they have a “team” property.

  1. In a view, I filter team members based their team (contains Team A) but somehow my view shows people from other teams too. It’s very basic filtering, I’m surprised this doesn’t work consistently (sometimes it does work, in the same view…).

  2. In the same view, I also have a list of percentage values. I want to highlight the rows whose percentage sum isn’t equal to 100%, but this also doesn’t work consistently.

How can I get Support to look into this, it’s very basic, it’s very disappointing.

Thanks!

Please share a (anonymised) copy of the doc. It is very difficult to assist with simply a description like this.

Could I simply submit a video to a support email or something like this?

This normaly occurs because your filtering is being done in the wrong array. Please, share a doc that show this problem.

If your doc has sensitive data, you can copy it and fill with dummy data, then share for everyone with link can edit, and paste the link here.

Best regards,
Arnhold

Bottom right of your doc you will see a ?, click on that too get into the support system.

Having said that, I am relatively certain that there is no bug, contains() has been in the CFL for many years with no reported problems.