Google form timestamp date-CodePudding

I am looking to timestamp my invoices via google forms.

I've tried numerous formulas, but they all seem to fall apart during the form submission.

=left(B2:B,(LEN(B2:B)-(FIND(" ",B2:B)-1)))

but it's causing the form to break.

CodePudding user response：

you need arrayformula. delete everything in C column and use this in C1:

={"Invoice date"; ARRAYFORMULA(IF(B2:B="";;TEXT(B2:B; "m/d/e")))}

or freeze it:

={"Invoice date"; ARRAYFORMULA(IF(INDIRECT("B2:B")="";;TEXT(INDIRECT("B2:B"); "m/d/e")))}