How to refer to cells on same row but different columns in table formulas?
Greetings
I have a repeat block that generates a table that consists of numeric values, then i add columns to the table and in its cells i want to create formulas that refer to the cells on the same row but on a previous column. to make my question clear, check the image in attachments, i have this repeated block table, in my estimate column cells i want to add a formula that divides the value in column "A" by 10 and store the result there..but i can't refer to a single cell as in tablecell(A1) for example as i need it to be dynamic to work with repeated block..how can i do this?
thanks