Google sheet formula gets lost in appsheet

[Chris_Bean1]

Hey folks

I have the following google formula in a sheet, and it returns an error when new rows are added via the app:

=IFERROR(INDEX(SORT(FILTER({‘Stockpile inspections log’!A:A, ‘Stockpile inspections log’!L:L}, ‘Stockpile inspections log’!B:B=D190), 1, FALSE), 1, 2), “”)

Appsheet has translated it as:

IFERROR(INDEX(SORT(FILTER(‘Stockpile inspections log’{!C[-45]:C[-45], ‘Stockpile inspections log’!C[-34]:L}, ‘Stockpile inspections log’!C[-44]:C[-44]=RC[-42]), 1, FALSE), 1, 2), “”)

Can anyone help get the appsheet syntax so it doesn’t return a #index error in the google sheet?

Thanks in advance

Chris

[Trevwiller]

You could try by entering the sheet formula into this section pictured below in the app editor. this will make the app evaluate the google sheet formula on sync. This is found inside the data table and inside the column editor.