Is there any way I can do countifs() functions directly in AppSheet. I need to count something based off of 3 criteria. For example, I need a formula that examines the following sheet and gives me a running count based off of 3 columns.
a specific user (i.e. useremail())
a specific type of service (i.e. Type 1) 3. has a specific status (i.e. Pending).
I’ve tried using the count(select(in())) function in a virtual column, but I can only get it return a single column of data, or compare a single “value” when counting. I can’t seem to nest it with “if()” or “and()”. Any ideas?
Thanks!
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |