Hi Everyone,
I need help with an expression.
I have a table “Familias” which have a key [ID Familia] and another column [Quantidade Elementos Agregado]
another table “Elementos da Familia” which have a key [ID Elemento Familia] has a Column [ID Familia] that is a “REF a part of” the first table “Familias”
I need the Familias[Quantidade Elementos Agregado] to calculate the amount of rows REFed on Elementos da Familia[ID Familia].
can someone help me as Appsheet doesn’t accept COUNTIF
thanx
Hello @Luis_Gomes_Machado, try:
COUNT([Related Elementos da Familia])
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |