Copy cell above in same collum + 1

[Lars]

Hi
To create a case number i would like to copy the value in the row before and add 1.
E. The nummer is 2000. Then when adding the new row i should look what the lates case number is+1

How would that formel look like?

[Steve]

Serial Numbers, If You Must Tips & Tricks 💡

Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …