With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, January 4, 2016
yogi_Compute Row By Row Running Total For CheckBook Register Where New Transaction Is Posted Above (Rather Than Below) Last Transaction Row
https://productforums.google.com/forum/#!topic/docs/XnDCCLsWOaI;context-place=forum/docs How to utilize ArrayFormula to auto-fill formula on new row insert on check book register? Hello,
I've been doing a ton of reading, but I'm having trouble figuring out how to utilize the ArrayFormula function to automatically fill in a formula when a new row is inserted.
I'm trying to develop a check book register, but one key difference is I want to insert new entries at the top (so that my current balance is always at the top and old transactions get pushed down). For the Balance field I'm calculating that by: (Previous Balance - New Transaction = Current Balance). (If a deposit occurred, I enter New Transaction as a negative number).
Now every time I want to insert a new transaction I want to insert a new row at the top and have the Balance formula auto-populate, however for the life of me I can't seem to get it right due to the circular reference error when referencing 'Previous Balance'.