IF Formulas and multiple contact list

I am creating a workflow for a group of people and I want to assign roles when a specific cell (i.e. Doc Type) has been selected. However, I use the formula:

=IF([Doc Type]@row = "ABC", "Sahand", IF([Doc Type]@row = "ABCD", "Jamie"))

However when the results only show my name within a text format instead of a contact.

Is there a solution to this problem?

I have heard I can create a master contact sheet, but seems to be difficult to replicate with no visual guidance.

Find more posts tagged with

Contacts

Formulas

Accepted answers

All comments

Genevieve P.

Hi @Sahand

If you're entering the formula into a Contact type of column, you can use an email address in the quotes instead of the name. This will then be an email that can be used as a contact in a Workflow or a Current User filter.

=IF([Doc Type]@row = "ABC", "genevieve@email.com")

Note that it won't look like a Contact, as it will display the email address in the cell instead of the contact name, but it will be functional as an email. Does that make sense?

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.