anybody know how to get formula MAX? I want t...

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 !

0 2 310
2 REPLIES 2

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

Top Labels in this Space