Expand my Community achievements bar.

SOLVED

Nesting Multiple If Statements in Mapping via Workfront Fusion

Avatar

Level 2

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 setupnest multiple ifs.jpg

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

 

KellieGardner_0-1716412124583.png

 




View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

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.

 

KellieGardner_0-1716412124583.png

 




Avatar

Community Advisor

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