Auto assign based on value in Field

Shawn Borror
Shawn Borror ✭✭
edited 12/09/19 in Formulas and Functions

I would like to auto assign and update the Assigned To field based on a value in another field. I've tried something like this; 

IF([Contract Type]=NDA, John Doe)

So if Contract Type equals NDA, then put John Doe in the Assigned To field otherwise keep blank. Can someone assist? 

Tags:

Comments

  • L_123
    L_123 ✭✭✭✭✭✭

    =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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!