I am making a credit card debt paydown sheet that I want the user to be able to add more rows and have the formulas automatically fill down the column. I tried ARRAYFORMULA but because the results of the columns rely on each other (ie, the first cell of each row is the starting day balance which requires the last cell of each row which is the end of day balance) it does not work because it thinks it's cyclical dependency. I don't want the user to have to drag the columns down manually. Any ideas? Sorry if this isn't clear enough or enough info to go off of.

I'm using Google Sheets, but it seems most of what works for Excel also works here, right?

  • The syntaxes of the two applications are not the same, especially for more complex setups. Google Sheets is a web application and off topic here on Superuser. We will move it to the web apps sister site. – music2myear Dec 1 '19 at 15:58
  • Welcome to Web Applications. There are several things that work the same way but others like arrays and "automation" don't. Please add sample input/output data in the question and demo spreadsheet shared with anyone with link are able to view only, a brief description of your search/research efforts and clarify if you are looking for a formula based solution or script based solution. – Rubén Dec 3 '19 at 13:57
  • 1
    Sheets is backward compatible with Excel formulas, you can literally import your Excel file into Sheets. Excel has nice auto-expanding tables and Sheets doesn't so you need to use ArrayFormula but you also want to delete unused rows permanently which is a feature Excel is lacking. – CodeCamper Dec 3 '19 at 15:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy