Dynamic reference to the cells


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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!