Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: If Formula Not Right - help!

Solved
Jump to Solution
1195 0
cancel
Showing results for 
Search instead for 
Did you mean: 
TRBS
5 - Automation Enthusiast
5 - Automation Enthusiast

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
5 - Automation Enthusiast
5 - Automation Enthusiast

Perfect, thank you @Sho !! That worked!