If Then Help
If a cell in Column A (titled Job) equals Marketing (from drop down in Column A), then adjacent cell in Column B (titled Responsible) equals Susan (name from contact list).Β I want someone to choose from a drop down in Column A, then based on their choice a particular person receives an email.Β Column A is set for multiple selections/entries, so I would prefer that Column B also allows forΒ multiple contacts.Β
Best Answer
-
Combining multiple contacts into a single cell can get tricky. Here is a link to an article that has the various different ways this can be achieved:
Answers
-
Combining multiple contacts into a single cell can get tricky. Here is a link to an article that has the various different ways this can be achieved:
-
Thank you, @Paul Newcome!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!