Hi everyone
I am struggling with expressions. I have the two following columns :
B
14499
A
12000
B
14499
A
12000
A
12000
B
14500
B
14500
A
10001
B
14500
A
10001
C
9200
C
9200
In a new form, when I first select B, I want the โINITIAL VALUEโ of column nยฐ2 to be 14500 (the last value linked to B). Is it possible with a combination of MAXROW / SELECT ? Or maybe a TAB with a FILTER but canโt put the tab name as a variable in expressions ?
Thanks for any advice
Yes, you should be able to use MAXROW(โฆ); however in order to find the last linked value to B you need a criteria like a Date/Time column or an increasing number or something to use in MAXROW() function and find the last row along with a
[Column]=โBโ condition.
@RezaRaoofi, Is _Rownumber column valid for doing this?
@Fernando_Lopez Yes, of course, but since we do not know all the details about the column structure I will leave that to @XJH_GOVโs discretion.
Hi all Many thanks for your advice. @Fernando_Lopez, youโre right, the only parameter I can use is the rownumber as DATE exists but not increasing nor any other param. Anyway I didnโt go this way because Im not used to interwined expressions in appsheet (Iโm familiar with code in general and itโs not intuitive at all) So I did it with adding a new tab with the last information I needed using spreadsheet formulas. ++
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |