EXPRESSION help

AppSheet AppSheet Q&A
,
1

How can I write a constraint expression that says,

IF there’s already a value of 220, make the next value is 221,

and IF there’s already a value of 221, make the next value is 230.

what I’m trying to say is there’s only two types in every tenths.

220 & 221,

230 & 231,

240 & 241

and so on

2

will this work? (not considering any error cases)

IF(MOD([col]/10) = 1,
 [col] + 9,
 [col] + 1
)
2 Likes
3

Next value formula:

[current value] + 8 * MOD([current value], 10) + 1

3 Likes