I have a Google Sheets file with specific data in 3 cells on Sheet 1. When a trigger happens that I have setup, I want the data in those 3 cells copied to a specific cell on Sheet 2. However, I need the data to fill in the next available row on Sheet 2 so that it doesn't overwrite data that is already present. (I.e. first time data gets copied from Sheet 1 cell A1 to Sheet 2 cell A1. Next time I want the data from Sheet 1 cell A1 to be copied to Sheet 2 cell A2...and so on). How can I indirectly address the row, column on Sheet 2? I do NOT want to use Google Apps Script to accomplish this.
1 Answers
If you use a "IF" with a "ISBLANK" or something like that?
https://support.google.com/docs/answer/3093290
I also found this guide https://www.3pieanalytics.com/excel-and-google-sheets-formulas-and-example/get-the-first-non-empty-cell-in-a-column-in-excel-and-google-sheets
Also, I understand that you do not want to use Apps script, just in case you want to give it a try, you can use this article as reference https://yagisanatode.com/2019/11/16/how-to-automatically-navigate-to-the-first-empty-row-in-a-google-sheet-using-google-apps-script/
Related