How to count all cells in row if text contain

I have [done by] row in "base" its content date and user name like "12/07/2022 13:54:36 superuser@gmail.com" 

 I need  to count  how many times cells in  [done by] contain the text "superuser"  in the virtual column, tried like this but it doesn't work

COUNT(FILTER("base", [done by] = "superuser"))

Thank you

0 5 144
5 REPLIES 5

Use CONTAINS() in your filtering.

I don't know why, but it counts 38 with any text, something wrong

COUNT(FILTER("base", CONTAINS([done by] , "@"))

Even with "superuser@"?

even with "superuser" or "powerbot" everytime 38 but actully its 64 for superuser and 0 for powerbot

I did bot for changes and return values, it works, but I think this is not the correct way

 

Top Labels in this Space