Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

invalid expression in the Formula field for a few of my formulas

I am trying to use the following formulas in appsheet that will be used in googlesheet, but it gives this errors (it works in thubkable x)
How can I change it to work in appsheet, DID TRY TO USE _THISRTOW, BUT GET SAME ERROR

Column 'Beskikbaar' in Table 'Eenhede_Schema' of Column Type 'Decimal' has an invalid expression in the Formula field

 

=INDIRECT("R"&ROW()-1&"C3",FALSE)+INDIRECT("R"&ROW()&"C6",FALSE)

 

Unable to find function 'ROW', did you mean 'NOW'?

Column 'Gebruik' in Table 'Eenhede_Schema' of Column Type 'Decimal' has an invalid expression in the Formula field.'

 

=INDIRECT("C"&ROW()-1)-INDIRECT("C"&ROW()

 

Unable to find function 'ROW', did you mean 'NOW'?

Column 'Koste' in Table 'Eenhede_Schema' of Column Type 'Decimal' has an invalid expression in the Formula field.'

 

=IFERROR(INDIRECT("R"&ROW()&"C"&COLUMN()-2,FALSE)/INDIRECT("R"&ROW()&"C"&COLUMN()-1,FALSE),"Error")'

 

Unable to find function 'ROW', did you mean 'NOW'?

Column 'PerDag' in Table 'Eenhede_Schema' of Column Type 'Decimal' has an invalid expression in the Formula field.

 

=ROUND(INDIRECT("G" & MAX(FILTER(ROW(G:G), G:G<>"", ROW(G:G)=MAX(FILTER(ROW(G:G), G:G<>""))))) * INDIRECT("D" & ROW()), 2)

 

Function 'FILTER' should have exactly two parameters, a table name and a filter condition

Solved Solved
0 4 866
1 ACCEPTED SOLUTION

Because there is NO function in AppSheet that is called ROW(). In the App formula field you can only use AppSheet's own expressions and functions, not the sheet's functions.

View solution in original post

4 REPLIES 4
Top Labels in this Space