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

[Mark_Pathfinder]

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?

[Steven_Coile]

What have you tried?

[Mark_Pathfinder]

COUNT(LIST and COUNT(SELECT

[Aleksi_Alkio]

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

[Jean_Marc_Perma]

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

[Mark_Pathfinder]

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

[Aleksi]

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