Appsheet formula counting rows

Hi All,
How to make
Auto Compute : SpreadSheet formula, always counting rows
example : when i recorded first transaction
=A1
when i recorded second transaction
=A2

Solved Solved
0 4 154
1 ACCEPTED SOLUTION

hmmmโ€ฆ I donโ€™t understand the purpose and better to avoid spreadsheet formula.

However, if you are at the column: โ€œUsing Rows Functionโ€ and want to get the column โ€œvalueโ€ using spreadsheet formula, in Appsheet you can put RC[-1].
In general, you can put a spreadsheet formula in google sheet and appsheet will translate that to RC something-something.

View solution in original post

4 REPLIES 4

hru
Participant V

use this:

 ROW()

Halo pak @Heru
I want to get reference Value Column = 2
3X_0_d_0d2e1c217febbf45b307fb320844cd17193e2bef.png
how to use to return the value?
actually i use =โ€œAโ€&ROW()

and return A2, not 2

hmmmโ€ฆ I donโ€™t understand the purpose and better to avoid spreadsheet formula.

However, if you are at the column: โ€œUsing Rows Functionโ€ and want to get the column โ€œvalueโ€ using spreadsheet formula, in Appsheet you can put RC[-1].
In general, you can put a spreadsheet formula in google sheet and appsheet will translate that to RC something-something.

Top Labels in this Space