I am trying to populate the "Recruiting Lead" field which a lookup field.
My use case is that when a new lead enters the system via referral, i.e Channel is Email Referral, Source is Email, Campaign is Referral by Employee and Medium is the name of the Employee (all of these fields are text fields)
I then want to assign the lead to the employee that referred him, so based on the Medium text field which has his name.
I am trying to add this to the process builder, to assign the recruiting lead if all the criteria match.
The issue I am facing is, the recruiting lead field is expecting an ID and I am providing it with Text Name.
So my question is how can I get the ID for the user, based on a text field value?
Can I do this using a formula field?