I have been using a Google Spreadsheet with a master list created from a Google Form. I created a new tab to rearrange the order of the entries to the newest ones on top.
However after those cells have been copied over and new entries are created from the form, if I put notes next to those cells, the cells (that were copied over) move down with each new entry though my notes column stays. It doesn't move down as well with the row I put it on. How do I fix this?
I haven't been able to find any examples. The imported data is the only thing moving down with new entries, while my working cells next to them don't move. Please advise.
Here is the formula I was using:
=query(Master!A2:I, "select * order by A desc", 1)