Auto assign based on value in Field
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?
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!