Change Sheet that Cells Link to

Cory Griffis
Cory Griffis ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hello Everyone:


I have an "Assigned To" column on a standard task list that is linked to a Project Directory. My goal is to be able to link the "Assigned To" column to the applicable role that is filled out in the Project Directory. I've gotten that to work, but the issue is that I need to duplicate both sheets for each project. Is there any way to update the sheet that the cells are linking to when I duplicate them without manually re-linking each cell?