I have an price variable that is calculated automatically by Spreadsheet formula (long formula). in the excel sheet works perfectly, but in the app the result is showed as $#Value
SUMIFS('Tracking de Gastos'!C9:C9,'Tracking de Gastos'!C3:C3,RC2,'Tracking de Gastos'!C4:C4,RC3,'Tracking de Gastos'!C5:C5,RC4,'Tracking de Gastos'!C6:C6,RC5,'Tracking de Gastos'!C10:C10,RC9)
โ
โ
โ
Someone knows how to fix it?
Likely the complexity of your formula is more than AppSheet can handle. AppSheet's ability to handle spreadsheet formulas is limited. Simple formulas will probably work, but complex formulas or formulas that use less-common functions may not. You may have found one of those formulas.
Thanks Steve, I solved creating a virtual column and applying the formula on it.
BR
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |