App created to receive data and generate a Registration Number.
The Registration Number appears after App is synced.
Problem is that the Registration Numbers are created in numberical/ascending order and you have to scroll through all numbers to get the one you created. So if there are 100 registration numbers, you have to page through 100 to see yours.
Is there any way to reverse that so that the one you created last appears first??
here is the array formula if that helps - thank you!
=ArrayFormula(if( len(RC[-17]:RC[-17]), “registration:TE18.” & text(row(RC[-17]:RC[-17]) - row(RC[-17]) + 1, “1000”), iferror(1/0) ))