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.
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!