Appsheet formula counting rows

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

use this:

 ROW()

2 Likes

Halo pak @Heru
I want to get reference Value Column = 2
image
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.

3 Likes