Nesting Multiple If Statements in Mapping via Workfront Fusion

[MeghanaKa1]

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

[KellieGWAB · Accepted solution]

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]

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

[KellieGWAB]

Good point Chris.