Sumif column loses ref after entry from appsheet

[chboktor]

Hi i have a Sumif column in my sheet which Appsheet adds perfectly as a new value, the problem is it keeps ruining previous Cells

Before entry

after entry 

if anyone can share ideas will be thankful

[Joseph_Seddik]

أهلاً بك في المنتدى!

Since you are using AppSheet, you should avoid using sheets formulas and instead employ equivalent AppSheet formulas to perform the desired calculations within the app. 

Please read this informative guide: 

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_R... - Google Cloud Community  

[chboktor]

i agree i faced an issue as i want to count how many times this item gets out so i use sumif "العدد" or so called amount of a certain item in spreadsheet only couldn't quite figure it out with appsheet function as it tried to sum() [العدد] but still did cross reference it with the selcted item btw i use a list for [الأصناف] also coming from another table 

[Joseph_Seddik]

You should be using SUM( SELECT(tableName[العدد], selectCondition) ).

Please read the guide I brought you.