Count rows from other table (COUNTIF)

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

0 2 765
2 REPLIES 2

Steve
Participant V

Hello @Luis_Gomes_Machado, try:

COUNT([Related Elementos da Familia])

Top Labels in this Space