I use the app to calculate tithes, a tenth of my gross income. I set up my spreadsheet with 3 principal functions. A page to add each income as I get my paychecks. This page calculates the % of each paycheck and a checkbox if paid up or not. Another page calculates the total tithes I currently owe. And another page records each completed tithe as I pay them.
Right now, I cannot figure out how to carry down the formulas on the spreadsheets as I add rows through the app. Which makes the app useless as I anyway need to go to my spreadsheets and carry down each formula.
(If I carry the formulas down in advance, say, for the next 50 rows, then adding a row through the app adds to row 51.)
Is there any (simple?) way to carry down formulas?
I tried using ArrayFormulas but I can’t get them to multiply 2 of the columns in each individual row, And I have a column of SUMIFS formulas.
Thanks,
(Also, when I delete rows, the check boxes remain in that column.)