COUNT IF hi, i'm building an app for the in...

AppSheet AppSheet Q&A
1

COUNT IF

hi,

i’m building an app for the invoices, and i need to count the issues invoices.

I’ve 2 column: ISSUED : YES/NOT INVOICE N° : where i must insert the formula

i checked https://help.appsheet.com/expressions/functions/count but i didn’t find the solution.

How can i do?

2

What have you tried?

3

COUNT(LIST and COUNT(SELECT

4

You can do that like COUNT(SELECT(TableName[KeyColumn],[ISSUED]=“Yes”))

5

Tx Aleksi for your support, i tried also COUNT(SELECT(TableName[KeyColumn], IN([ISSUED], {“Yes”}) and it also works

6

Hello there, I am from Mauritius, Indian Ocean and have a similar issue. Can you please assist me with an issue? How can I count a field in a related table? That is I have an order table that I want to sum up the total units ordered in the order sum table. Related with the OrderID field. Thx

7

Try something like SUM([RelatedOrderDetails][Units]).