Unable to use a simple formula in the "Assigned To" (Contact) column

Gopikrishna Mamidipudi
Gopikrishna Mamidipudi ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I have a project schedule that looks something like this:

Row | Task        |    Assigned To

1      | Task1      |    Name1

2      | Task2      |    Name2

3      | Task3      |    Name3

4      | Task4      |    Name1

5      | Task5      |    Name1

6      | Task6      |    Name2

Once I assign Task1 to Name1 in Row 1, I want Task4, Task5 to change to whatever Name1 is.

So I use the formula =[Assigned to]1 in rows 4 and 5 and it keeps getting erased and nothing happens. What am I doing wrong?

 

 

Comments