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?