Workflow - recognising email domain as part of "assigned to" column
I have two columns:
- Assigned to - this is set as the "contact list" property and linked to the address book so you can put an email address e.g. "[email protected]". However in the field it would show up as "firstname lastname" without the domain at the end
- Company - dropdown box with 2 company names i.e smartsheets and Google
I am trying to create a workflow that if "assigned to" contains "smartsheets.com" then the "Company" cell would autopopulate to "smartsheet"
Really trying to avoid a formula as it doesn't scale up well if you have over 20 companies etc.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!