Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Cell reference expression or parent reference?
=Task$344 + " - LAYOUT - " + [Assigned To]345
I have a formula in a child row here. Task$344 refers to the parent row, and [Assigned To]345 refers to an adjacent cell on the same row. When I copy and paste the parent and child rows, Task reference remains locked to parent row 344 and Assigned To autofills to the new row number. I have to manually change the parent reference each time I paste in new rows.
The options , as I understand, are:
1. Lock the reference using $.
2. Autofill the reference which is done automatically.
My question is: is there a way or formula to reference parent rows whilst still utilizing drag and drop? Such as
I would like to drag and drop, but I would like the child rows to have their reference locked to the parent.