- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 27, 2023 06:22 PM
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))
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 27, 2023 06:37 PM
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"
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 27, 2023 06:37 PM
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"
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 28, 2023 11:35 AM
Perfect, thank you @Sho !! That worked!
