Contact List Formula

Khari Shiver
Khari Shiver ✭✭✭✭✭
edited 08/09/21 in Formulas and Functions


I'm not sure if my approach is correct but I'm trying to use an IF statement in a contact column to have a specific contact listed based on the value in another column. The formula is fairly straightforward, but the problem I'm having is the IF statement displays the result as text. I did some digging and there seems to be a way to use INDEX and MATCH to accomplish what I'd like to do but I don't fully understand the syntax. I've not been able to find any examples that illustrate it either.

In a nutshell I have a form that in part collects the supervisor, called "Supervisor 1" which is a contact column, for a new hire. If the new hire is a shared employee a value of "Yes" is in the "Shared Employee" column. I have a third column called "Shared Supervisor" that is also a contact column. There's a third "Supervisor" column into which I would like the value in "Supervisor 1" to populate if "Shared Employee" is "No" or the value in "Shared Supervisor" to populate if "Shared Employee" is "Yes." Via an IF statement, I can get the desired behavior but it's just text. I'd like it to be a contact and I'm not sure how to achieve that.

Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!