Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Is there any way I can do countifs() function...

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.

  1. a specific user (i.e. useremail())

  2. 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!

0 5 3,937
5 REPLIES 5
Top Labels in this Space