How to identify if Contact -OR- Text is in a Contact column?
Hi everyone -
We have starter task templates that we use when we initiate certain types of work. The templates have a Contact List column that is initially populated with ROLES (e.g. project manager, designer, tester, etc).
The ROLES are then populated by the project team with the actual CONTACT names, based on the team members of that specific project.
Question: Is there a formula I can use to test if the contents of a cell in the Contact List Column is an actual contact vs just plain text denoting the role?
Help Article Resources
Check out the Formula Handbook template!