Curious.... I am using Max()+1 on a column. ...

(Dave Ranglos) #1

Curious…

I am using Max()+1 on a column. I have other “key” fields that I am using.

Trying to “re sequence” the rows of the column, and associated refs, after a row is

deleted? After “delete”, a “blank” row is left in the gsheet? Some way to calculate the missing value based on the “value above”, “value below”. The column is sorted Z-A.

row 1 row 2 row 3

row 4

row 6 row 7

Anyways… hope the New Year is off to a Good Start at AppSheet!!

(Aleksi Alkio) #2

You could read the below key column’s value with the MAXROW. You can filter the existing list like MAXROW(“TableName”,"_ROWNUMBER",[_ROWNUMBER]<[_THISROW].[_ROWNUMBER]). Idea is the same for the below rows.