Get Google Form Response number into Response sheet

84 views Asked by At

I have a google form saving responses in a google sheet. Somehow the form line number and the form responses have gotten out of sync. I, looking for a way to iterate through the current responses and input a the response number into a cell in the response sheet.

Response Number Example

My hunch is to grab the response array form.getResponses() and use indexOf() but I cant seem to make it work. When trying to get the indexOf(timestamp) I get -1 which is not found in the array. Any ideas?

0

There are 0 answers