How to make
Auto Compute : SpreadSheet formula, always counting rows
example : when i recorded first transaction
when i recorded second transaction
Halo pak @Heru
I want to get reference Value Column = 2
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.