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: Dept Automation Lead So what I'm trying to create: IF Dept =…
