Skip to main content
MeghanaKa1
Level 2
May 22, 2024 5:38 PM UTC
Solved

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
KellieGardner
KellieGardnerAccepted solution
Community Advisor
May 22, 2024 9:09 PM UTC

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.

 

 

View in thread

3 replies

KellieGardner
Community Advisor
KellieGardnerCommunity AdvisorAccepted solution
Community Advisor
May 22, 2024 9:09 PM UTC

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.

 

 

Translate
    ChrisStephens
    Community Advisor
    ChrisStephensCommunity Advisor
    Community Advisor
    May 23, 2024 12:58 PM UTC

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

    Translate
      KellieGardner
      Community Advisor
      KellieGardnerCommunity Advisor
      Community Advisor
      May 28, 2024 2:58 PM UTC

      Good point Chris. 

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...