MAX

AppSheet AppSheet Q&A
1

Hi all, how to get max value and + 1 for type of product added in single sheet

like

prod value

a 1

a 2

b 1

c 1

c 2

a 3

2

Serial Numbers, If You Must - Google Cloud Community

1 Like
3 
MAX(
	SELECT(
		TableName[Value],
		[Prod] = [_THISROW].[Prod]
	)
) + 1
2 Likes