count

AppSheet AppSheet Q&A
,
1

i want to use countifs to count multiple rows that meet specific row requirements

for example i have a table “activity” with program, service and visit date as columns program refs a different table program type and service refs table activity type

how to i display a count of specific program type , service with a specified date range

Thank you

2

In which table(s) do you want to calculate it? It sounds you would like to do the calculation in the “Program type” and “Activity type” tables, right?

3

An expression like this will give you the desired count:

COUNT(
  FILTER(
    "Activity",
    AND(
      (program-type = [Program].[Type]),
      (service = [Service]),
      (visit-date-start <= [Visit date]),
      (visit-date-end > [Visit date])
    )
  )
)

Replace program-type with an expression that provides the program type to find, service with the service to find, and visit-date-start and -end with the start and end dates of the search range.