Dynamic reference to the cells
Options
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
Answers
-
I believe the resource above should help you do this.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!