How to count all cells in row if text contain

AppSheet AppSheet Q&A
,
1

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

2

Use CONTAINS() in your filtering.

1 Like
3

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

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

4

Even with “superuser@”?

1 Like
5

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

6

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