Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

If Formula Not Right - help!

Topic Labels: Formulas
Solved
Jump to Solution
1479 2
cancel
Showing results for 
Search instead for 
Did you mean: 
TRBS
6 - Interface Innovator
6 - Interface Innovator

I am struggling here! I thought I was getting better - but I need help. Thank you in advance!

My column is "Sourcing Manager" and I am trying to create another column with a formula to add their email automatically.

If the Sourcing Manager is "Monique", then it should list Monique@theroomblocksource.com

If the Sourcing Manager is "Karen", then it should list karen@theroomblocksource.com

If the Sourcing Manager any other name, then it should list hello@theroomblocksource.com

This is the formula I am trying:

IF({Sourcing Manager}=Monque, monique@theroomblocksource.com, IF({Sourcing Manager} = Karen, karen@theroomblocksource.com, hello@theroomblocksource.com))

 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

The missing "String" is the problem.

IF(
  {Sourcing Manager}="Monque",
  "monique@theroomblocksource.com",
  IF({Sourcing Manager} = "Karen",
    "karen@theroomblocksource.com",
    "hello@theroomblocksource.com"
    )
)

SWITCH function is much easier

SWITCH({Sourcing Manager},
  "Monque", "monique@theroomblocksource.com",
  "Karen", "karen@theroomblocksource.com",
  "hello@theroomblocksource.com"
)

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

The missing "String" is the problem.

IF(
  {Sourcing Manager}="Monque",
  "monique@theroomblocksource.com",
  IF({Sourcing Manager} = "Karen",
    "karen@theroomblocksource.com",
    "hello@theroomblocksource.com"
    )
)

SWITCH function is much easier

SWITCH({Sourcing Manager},
  "Monque", "monique@theroomblocksource.com",
  "Karen", "karen@theroomblocksource.com",
  "hello@theroomblocksource.com"
)

 

TRBS
6 - Interface Innovator
6 - Interface Innovator

Perfect, thank you @Sho !! That worked!