Hi - I've been reading through the community posts and trying a variety of answers, but nothing I've tried seems to be working so I thought I'd post and ask for help. :)
I am trying to establish a column that has an answer based on another cell. My columns:
So what I'm trying to create:
IF Dept = Global, then Automation Lead = Global
IF Dept = Anything else, then Automation Lead = Taylor Freeman
The Dept column is formatted as a drop down list; the Automation lead column is formatted as a Contact column if that matters.
Would really appreciate any help.