Making a spreadsheet formula relative to the record

hi,

I want to apply an excel function to a field using spreadsheet function in auto compute. the function refers to inline cells only. however,when the data is synced AppSheet treats the cell references as absolute instead of relative. for example, the formula references cell E2 in the spreadsheet. then for row 3 it is still referencing E2, but I want it to reference E3 and so on.

Any Ideas on how to make this happen

Thanks I advance!!