Adding an AND statement to a formula

AppSheet AppSheet Q&A
1

Hello,

I currently have this formula that works “Count(select(Household[Status],or([Status]=“Client: Current”,[Status]=“Client: Firm Lead”)))”

This adds up the total number of rows that have a status of “Client: Current” or “Client: Firm Lead”. Essentially giving me the total number of clients.

I want to add another condition to the formula. The clients are filtered into three different tiers (Gold, Silver, Bronze). So I would like to get the total number of “Gold” clients. I have attempted to use FILTER or AND but have been unsuccessful.

Any input is appreciated, thanks.

2

Try..
COUNT(SELECT(Household[Status],
AND(
[Tier]=“Gold”,
IN([Status],{“Client: Current”,“Client: Firm Lead”})
)
))

3

Thank you very much. I had to tweak the formula you posted a little bit in order to get it to work. Here is the final formula in case it helps anyone else in the future. The segment is the tier of the client.

COUNT(SELECT(Household[Segment],AND([Segment]=“Gold”,IN([Status],{“Client: Current”,“Client: Firm Lead”}))))