Row number from Google sheets

Good day,

I am using Google forms to add participants to a list, but Google forms do not automatically add incremental numbers, for example in my form it only add Timestamp, Member name and timestamp.
Now, the first entry will be placed in Row 2 (as the first row is used for headers in the Google Sheet.

I need a code that display the row number minus one as the entry number.

This is what I currently have:

Any help perhaps?

Easiest way is to add an indexing array formula to your google response sheet.

e.g. place this formula in cell D1

={"Index";ArrayFormula(if(C2:C<>"",row(D2:D)-1))}

Remove any unused rows from the responses sheet to prevent entries being placed at the bottom.
Do not manually enter anything into column D

Thanks, I am using that at the moment, but, it is not "user friendly" as I would like the app to seamlessly integrate with sheets, without other custom formulas. I know how to do it, but a sports coach might not be so computer literate :frowning:

In which case, call down your data from google sheets, and convert to a list.

Use the indexing in the list, just remove 1 from the index of an item (exclude the first item) and insert this as the first item for each response. You should end up with:

[1,17/08/2020 15:45:26,Test1,48],[2,.....],[3,....