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! Go to 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.
use this:
ROW()
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.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |