Answer the question
In order to leave comments, you need to log in
How, when filling out a table through a form, columns with pre-written formulas were not cleared?
People who filled out the form need to know the notice number. I wrote down the formula in the "Notice number" column, but when filling out the form, the values in the columns that are not present in the forms are erased.
Answer the question
In order to leave comments, you need to log in
Transfer the data from the form sheet to another sheet, and work with it there.
=ARRAYFORMULA(Ответы!A:Z)
Or instead of the usual formula, use "bulk", for the entire column
=ARRAYFORMULA("Т."&SEQUENCE(СЧЁТЗ(B:B)-1;1;1)&"-21")
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question