How to make cells autocomplete in Google Sheets when adding a new response from Google Forms?

Question

Google Sheets

Created a Google Spreadsheet and attached a form to it. When filling out the form, there is a column F in which the rows should be automatically filled with the same "Done" value. Wrote the formula =IF(A1<>0;"Done";)
It works if you edit field A1 manually, but if it is filled out through a Google form, then the formula is automatically erased in column F.
P.S. Column F is not used in the Google form and when filling out an empty one.
Can some scenario solve this issue?
Thanks

Answer 1

You need to use formula ARRAYFORMULAor INDEX.
Type =ARRAYFORMULA(IF(A1:A<>0;"Done";))
See How to stretch formula in Form answers in Spreadsheets?