S
S
Sergey Kolesnik2020-08-10 09:41:16
Google Sheets
Sergey Kolesnik, 2020-08-10 09:41:16

How to design a Google spreadsheet so that when you add a value to cell A1, it shifts to the cell below?

How to design a Google spreadsheet so that when a value is added to cell A1, it would be shifted to a cell below A2 and the next time a new value was added to cell A1, the value would also be shifted to a cell below and shift what was already in its place? That is, the new added value was shifted to A2 and its old value was shifted to a cell below A3, and so on ad infinitum I
5f30ebe65e748210233705.jpeg

will immediately ask you to explain in a simpler way)
Thank you!

Answer the question

In order to leave comments, you need to log in

2 answer(s)
N
Noir, 2020-08-10
@Serhii_Kolesnyk

via google app script
simple check with below line insert

O
OnYourLips, 2015-03-16
@OnYourLips

Because it has an error. Need to debug.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question