Answer the question
In order to leave comments, you need to log in
How to set up automatic insertion of a formula in an inserted cell in Google Sheets?
Hello
There is column B in the Google Spreadsheet file, it has 10 rows with names, and there is column D, the composition of which, according to the formula, depends on the cells of column B, for example, in cell D5 the formula is: "=B5", in D6 the formula is: "=B6" etc. So if I insert a row with data in the middle of the range of column B, then the resulting cell in column D remains empty. How can I make it automatically take the formula of neighboring cells?
I made an example.
I met solutions for Excel, but there are no such menu items in Google spreadsheets.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question