anybody know how to get formula MAX? I want to search maximum number in column “ID” and add 1 value.
In google spreadsheet my formula working but in AppSheet not
Thanks for help !
Try MAX(TableName[ID])+1
@Aleksander_Rogowski Keep in mind that if 2 users are doing it in the same time (or if one of them is offline), you’ll end up with 2 rows with the same ID, since the ID+1 value will be written only on sync. You can workaround this by keeping your formula in the spreadsheet and using a spreadsheet formula:
help.appsheet.com - Spreadsheet Formulas Spreadsheet Formulas help.appsheet.com
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |