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?
Help Article Resources
Check out the Formula Handbook template!