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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!