Contact List formula just displays as contact "name"
I am trying to set up a template (PMO Template Set - Project Plan Sheet) so that people who are Assigned to certain project roles get automatically assigned to the appropriate Project Task. But when I type "=[Assigned To]3" for a certain task, it just displays the formula text instead of populating the cell with the contact listed in row3 of the Assigned To column. The same happens with any formula I use in this column - it seems to think the formula is the text of a contact name. The Assigned To column is not set to allow multiple contacts. Any suggestions on address this issue?
Help Article Resources
Check out the Formula Handbook template!