I have data with random serial numbers, for example
3. alex
2. steve
4. josh
1. john
I want to make a pdf and want to make it sequential by number, what is the formula ?
You could try using EXTRACTNUMBERS() function to get the number value from that column containing 3. alex etc. in another number type column.
Thereafter you could ORDERBY() records by those extracted numbers column in your template <<START>> expression.
EXTRACTNUMBERS() - AppSheet Help
Use templates in an automation - AppSheet Help
Use Start expressions in templates - AppSheet Help
Dieser Ausdruck gewährt dies:
ORDERBY(Tabelle[KEY], [Spaltenname])
Der Ausdruck kann auch in entsprechender Spalte mit "TYP Text" als "Valid If Ausdruck" verwendet werden.
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
13 |