Hi everyone, I’m trying to create a tab in google sheets that acts like a bank register with multiple accounts. It would have a sender ID column, a receiver ID column and a transaction amount column. What I’m now trying to build is a column which outputs a balance for the sender at the point the tr…

Hi Ed, I have altered the script and the sheet to make it work. [image] The script now takes the range of values from column D, filter out null values, then determine the next empty row to copy the formula into using autoFillToNeighbour. I have also removed the “bank” rows and add the initial 10…

Hi Ed, Please allow me the access to edit the file. I need to see the script and test it. Thank you!

Have a look at the Currency Transfer/Purchase example in https://concepts.glideapp.io/ . It’s old and could use some updating, but maybe it will give you some ideas.

Here are some notes. Accessing the scripts: Navigate to Tools > Script Editor. [image] This script copies down the formula in column “4” (which is D), you don’t need to modify anything other than the Sheet Name. It is “Bank account” here, but in your file it is “Sheet1”, so I have changed the n…

Fantastic, it works! I’ll try to integrate this now into my app taking into account your very helpful notes. Thank you so much Thinh!!

Thank you Jeff! I’ll take a look :slight_smile:

Hi Thinh. I’ve tried to integrate this into my app and all seems to work well apart from one issue: When manually generating a new row through the ‘add new rows at bottom’ button it works great. The issue is that the data is coming in through a form on a second tab which is pushed through to sheet …

I’ve recorded the issue below as well [Album] Imgur [Imgur]

Is there more to this 500 row thing or is it a formula issue??? [image] If x Then y Else Do Nothing Report a Bug Hello, I’m not sure if this counts as a bug or a feature request, but it may be causing my app to crash. I have an if then else statement set up as follows: …

Multiple criteria sumif array formula with logic

Ask for Help

Jeff_Hager May 16, 2020, 9:46pm 14

Is there more to this 500 row thing or is it a formula issue???

Topic		Replies	Views
Looking for advanced google sheet formulas Ask for Help	15	1504	March 12, 2020
Array formula summation is not correct Ask for Help	14	459	October 13, 2021
Some functions don't work with Arrayformula Ask for Help	14	360	November 23, 2021
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help	125	14442	September 9, 2022
Adding Rows Ask for Help	7	341	November 18, 2021

Multiple criteria sumif array formula with logic

Related topics