Search and replace contacts

edited 12/09/19 in Smartsheet Basics

Hello everyone! I'm having some issues getting my head around the search & replace function:

I have a standard project task with placeholder values for assignees (Ie "Project Manager" or "Consultant). In order to avoid manually entering every contact, I want to search and replace "Project Manager" with "John Doe". Unfortunately, this just changes the placeholder into plain text, and then I have to manually click it and link the flat text "John Doe" to the contact "". This plan is very, very extensive and doing this manually is a huge time sink I'm trying to automate

I tried to do a substitution formula, but unfortunately (or should I say unformulately?) Contact rows do not seem to be compatible with them.

Has anyone required to do a similar thing?

Thank you!