Wrong Spreadsheet formula generated with R column

[Jim_Ho]

Hi Everyone,

I have a spreadsheet formula

XLOOKUP(RC[-40],‘SHEET1’!B:B,‘SHEET1’!R:R)

When new record is generated, it becomes

=XLOOKUP(E158,‘SHEET1’!B:B,‘SHEET1’!AT158)

is it a bug?

[dbaum]

Try using R1C1 notation throughout the entire formula.

[Steve]

Spreadsheet formulas - AppSheet Help