I'm using the following formula to create an auto increment to form responses. I need the starting value of "100000"
and all subsequent values to be a number, not a string.
Formula
=arrayformula( if( len(A2:A), text(row(A2:A) - row(A2) + 1, "100000"), iferror(1/0) ) )
How can I update the above formula so it outputs a number value, not a string showing a number?
=ISNUMBER(E2)
to test it and get "false". I need to figure out how to return the auto increment number as a 'value'.