New answers tagged google-forms
There is no way that the Form can resolve the issue for previously entered response - it has taken the input value and saved it as a number, meaning the leading values are lost, ie the sheet doesn't know if they were there or not. You will have to fix them manually. What happens if you format the column in the responses spreadsheet as text? Do ...
The absolute simplest approach is to just StoreNumber onto the form, and ask them to complete the form once for each store that they own. This is the easiest way to deal with the fact that they may own different numbers, eg one may have two, another four.
EDIT to include the essential information from the link, original answer here at bottom. The first two methods do not solve my problem, as cells referred to in formula continue to update the reference as extra records are added from the form. Method 3 answers my problem as specified in the question.... Method 1: Duplicate the sheet. Click on the little ...
For "Is it possible in Google Form to give a unique value to each row it inserts into the spreadsheet as well as the timestamp?" while also allowing for deletion of a row in the Form responses sheet before the addition of a further Response without duplicating values, this should work: =iferror(ArrayFormula(match(A1:A,A:A,0)),"")
Whether or not this is practical may depend on the formulae you are using (which you don’t show) but for something very simple like =Sum(A1:B2) you might switch to View, All formulae and replace ( with ($ and : with :$. Then transpose, repeat the process and transpose back. Otherwise “Search using regular expressions” may help.
Maybe this has changed in new Google Sheets because in the second and subsequent Forms it seems possible to select Responses, Choose response destination: New sheet in an existing spreadsheet..., Choose: find the Response Sheet for the first Form, Select and for this to work.
Top 50 recent answers are included