Skip to main content
Solved

If Formula Not Right - help!

  • July 28, 2023
  • 2 replies
  • 25 views
T
Forum|alt.badge.img+6
  • TRBS
  • Known Participant

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))

 

Best answer by Sho

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" )

 

2 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • Answer
  • July 28, 2023

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" )

 

T
Forum|alt.badge.img+6
  • TRBS
  • Author
  • Known Participant
  • July 28, 2023

Perfect, thank you @Sho !! That worked!

Terms & ConditionsAccessibility statement