I have a formula in google sheet to create a serial number order wise like A0001,A0002-A9999 and then B series starts like B0001-B9999 till Z. I want to add this formula in appsheet because the google sheet formula show sync to compute in the app everytime.
Is that possible?
the google sheet formula is -
={"#";ARRAYFORMULA(IF(C2:C="",,IF(SEQUENCE(26000,1,1,1)<=26000, CHAR(65+INT((SEQUENCE(26000,1,1,1)-1)/9999)) & TEXT(MOD(SEQUENCE(26000,1,1,1)-1,9999)+1,"0000"),"")))}
User | Count |
---|---|
17 | |
14 | |
10 | |
7 | |
4 |