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.
How do I link Cells to assign people?
In the sheet shown below I have some tasks assigned to specific people regardless of who is hired. Other tasks get assigned based on who the manager of the new hire is (see "manager" in the assigned to field). I have added a row for who the manager is (row 5). When a new person is hired, I would like to add the manager's name into row 5 and have all the "manager" assigned to cells auto fill in based on that value.
I tried using =[task name]5 but I get an error that that's not supported. I am hoping that if I can figure out the correct formula I can also have the reminders go to the person that gets assigned as long as the sheet is also shared with them. Is this possible?