Trying to write a forumula based on managers from a contact list


I need to write an IF statement to look for "Managers" in the Team Manager column (contact list) and if they match put the corresponding region in the "Manager Region" column.

EX: IF Team Manager, is Full Name 1, Full Name 2 put US-East, else if Full Name 3, 4 US- West, etc.

IS it possible ?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!