Skip to main content
MeghanaKa1
Level 2
May 22, 2024
Répondu

Nesting Multiple If Statements in Mapping via Workfront Fusion

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

Ce sujet a été fermé aux réponses.
Meilleure réponse par 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.

 

 

3 commentaires

KellieGardner
Community Advisor
KellieGardnerCommunity AdvisorRéponse
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
    ChrisStephensCommunity 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
      KellieGardnerCommunity Advisor
      Community Advisor
      May 28, 2024

      Good point Chris. 

      Conditions d'utilisationAccessibility statement

      Loading footer...