A
A
astromayka2020-12-07 11:03:38
Google Sheets
astromayka, 2020-12-07 11:03:38

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.
5fcde1460594e632399893.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2020-12-07
@astromayka

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 question

Ask a Question

731 491 924 answers to any question