Auto assign based on value in Field
Comments

=IF([Contract Type]="NDA", index(Contacts:Contacts,match("John Doe",Contacts:Contacts,0))
you need to have an available list of contacts in a contact list column, then use index match in order to grab the correct one. Otherwise it will not associate the email with the name. You can have this list on another sheet, or in a helper column, but it needs to be made available. Then you can use the formula above to return the correct value.
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!