Spreadsheet formula is wrong

(Mobile Tuberculosis) #1

Hello, I have a spreadsheet formula and it is as follows: if(isna(filter(‘F7’!B:B,‘F7’!B:B=C2)),0,rows(filter(‘F7’!B:B,‘F7’!B:B=C2)))
but, regardless of structure regeneration, AppSheet always returns the formula
which of course, is wrong.

*this is how it appears in the spreadsheet upon syncing a new row.

When I try to change the formula from the editor, AppSheet keeps telling me there’s a formula mismatch and I should check my app.