Contact List formula just displays as contact "name"

Hi all,

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?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!