Sliced data contains some rows not existing in source table

[Roberta_Zola]

hello there, hope you are doing good. I have a slice that works well for most of the output but i cannot figure out why it returns 2 kind of unexpected rows.
one row (that fits the row filter condition) is doubled, meaning that it appears twice in the slice data.
the other row does not fit the row filter condition, but still it is shown.
filter condition is a simple one: column A=“Y”
i’ve regenerated many times the source table structure (since column A can change values) but still these 2 problems stay there.
i’ve created a new slice (with same condition as before), still the 2 unexpected rows in the related UX and also in view slice data.
any clue from your side? thanks!

[Eloy_Paredes_He]

Hello @Roberta_Zola. Are you using any kind of expression?

[Roberta_Zola]

hello Henriquez, just using the row filter condition (see my reply to @Steve ).
i don’t use expressions in appsheet but i have different formulas set in the source google spreadsheet.
probably the issue is not on slice but on source table that has lost the sync with my original google spreadsheet.
see screenshot of source table (as per appsheet) while my google file does not longer have this row.

[Koichi_Tsuji]

Most of those odd behavior is coming from spreadsheet expression which is not recommended to use in general when we use the sheet as source to Appsheet App.
I suggeste you remove the expression within spreadsheet as much as possible (ideally no spreadsheet formula) and do the same calculation within APP by appsheet expressions.

[Roberta_Zola]

Got it, thanks. I will try to rebuild the app.

[Steve]

Roberta_Zola:

one row (that fits the row filter condition) is doubled, meaning that it appears twice in the slice data.

How are you viewing the contents of the slice?

Please post a screenshot demonstrating the doubled row.

Roberta_Zola:

the other row does not fit the row filter condition, but still it is shown.

Please post a screenshot of the complete row filter expression.

[Roberta_Zola]

hi Steve, first line is the one that has no longer the “Y” condition in my source table

last 2 lines are the double
here is the screen shot

[Roberta_Zola]

that’s the row filter expression
where column [wish to sell] is set as TEXT