Want a formula to create a serial number in appsheet

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"),"")))}

0 3 1,498
3 REPLIES 3