Nesting Multiple If Statements in Mapping via Workfront Fusion | Community
Skip to main content
Level 2
May 22, 2024
Solved

Nesting Multiple If Statements in Mapping via Workfront Fusion

  • May 22, 2024
  • 1 reply
  • 1063 views

How can I nest multiple If statements in mapping? I want to assign IDs based on name, but have not been able to get this to work. Please see screenshot for current setup

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by KellieGardner

Hi Meghan -

 

In your second set of IFs you have the = sign setup wrong in the formula, it's preceding your "name" and it should come after.

 

 

1 reply

KellieGardner
Community Advisor
KellieGardnerCommunity AdvisorAccepted solution
Community Advisor
May 22, 2024

Hi Meghan -

 

In your second set of IFs you have the = sign setup wrong in the formula, it's preceding your "name" and it should come after.

 

 

ChrisStephens
Community Advisor
Community Advisor
May 23, 2024

To add on to what KellieGardner said, I would also recommend to not use nested if statements like this, and instead use a switch statement, so it would look like this.

 

switch({3.name};Sam Smith;c3a09;Jon John;62e80;HIllary Jon;6123;"")

KellieGardner
Community Advisor
Community Advisor
May 28, 2024

Good point Chris.