Formulas in Contacts Columns
I have researched this issue through multiple earlier discussions, but I can't find a permanent or reliable solution.
I am trying to use formulas to populate contacts through multiple stages of a workflow- currently 2 sheets- and cannot replicate the successful behavior documented in many other threads.
Sheet 1: Job Posting requisition. Rows in this sheet are created via a form that requires the user to be logged in. The user is then assigned to the "Submitted by" column, an Auto-Number/Created By column. In the very next column, I have a Contact column with the formula =[Submitted by]@row. My expectation is to get the standard contact field structure. Instead, I get an email address.
What I get:
The only way to get to "Expected" is to click on the Hiring Manager cell and select the contact from the options.
Notes: The contact column is not restricted to a specific list (tried that- didn't change the outcome) and has Multiple unchecked
Sheet 2: Onboarding checklist. Once the requisition is filled with a candidate, I have a second sheet that uses a VLOOKUP via the Requisition ID to populate multiple columns, including Hiring Manager. Here, I get the same issue- I can return the email format, but can't get a contact with name. I even tried a helper column to just lookup the Submitted by- same behavior
Can anyone advise if my expectations are possible- to get a Contact in the standard contact format using any formula?
Help Article Resources
Check out the Formula Handbook template!