Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

IF Formula referencing one column to fill in another

edited 12/09/19 in Archived 2017 Posts

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: 


Automation Lead


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. 








This discussion has been closed.