Appsheet formula counting rows

[adityo_reksopra]

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

[hru]

use this:

 ROW()

[adityo_reksopra]

Halo pak @Heru
I want to get reference Value Column = 2

how to use to return the value?
actually i use =“A”&ROW()

[adityo_reksopra]

and return A2, not 2

[hru · 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.