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
أهلاً بك في المنتدى!
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
2 Likes
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
You should be using SUM( SELECT(tableName[العدد], selectCondition) ).
Please read the guide I brought you.
1 Like