Google sheet : Create unique ID based on timestamp-CodePudding

I tried to follow up on a tutorial to create a unique ID based on a timestamp from a google form in a google sheet. However, I tried a few things and not a single one works.

I would like some advice on what I do wrong to improve myself.

I tried to have id start at B1 and follow the line 1

I used this :

={"Inquiry_id"; Arrayformula(if(len(B4:4), "INQ"&text(row(B1:1)-1, "000"),))}

Here is a picture of the current situation:

Thanks a lot

Have a nice day

CodePudding user response：

Try

={"Inquiry_id", Arrayformula(if(len(B4:4), "INQ"&text(COLUMN(B1:1)-1, "000"),))}

assuming your row delimiters are commas (,)

otherwise for French settings:

={"Inquiry_id"\ Arrayformula(if(len(B4:4); "INQ"&text(COLUMN(B1:1)-1; "000");))}