Dynamic reference to the cells

Anil Rattan

Hi,

I have one Smart-sheet A with all the details. One of the column is Date.

I created an another Smart sheet B where I have all the formulas. On of the formula I am using is =ROUNDUP(MONTH({QMS GAP Analysis Range 9}, 2))

As each cell in the Smart-sheet A has different dates. I can't drag the formula in the Smart-sheet B to dynamically link to all the cell, such as

Smart-sheet A Cell A = Smart-sheet B Cell A

Smart-sheet A Cell B = Smart-sheet B Cell B

Smart-sheet A Cell C = Smart-sheet B Cell C

& so on.

Any help will be appreciated.

Thanks!

Anil

L_123

https://community.smartsheet.com/discussion/36341/index-and-match

I believe the resource above should help you do this.