Nesting IF statements in Calculated Field | Community
Skip to main content
L
lauram26269131
Level 2
November 15, 2018
Question

Nesting IF statements in Calculated Field

  • November 15, 2018
  • 2 replies
  • 1436 views
I'm currently stuck with a problem when it comes to nested statements. I'll try to explain what I'm trying to do. Choice 1 Choice 2 Choice 3 I have 3 choices that my calculation is looking at. Each only one choice will have data and my calculated field will display that data. This is the calculation I have right now. IF(ISBLANK(Choice 1,Choice 2),CONCAT(Choice 3),IF(ISBLANK(Choice 3,Choice 2),CONCAT(Choice 1),IF(ISBLANK(Choice 1,Choice 3),CONCAT(Choice 2)))) With this expression, I can get Choice 3 and Choice 1 to appear in the calculated field. However, when I add in the 3rd statement, Choice 2 is not appearing. Not sure if it's something to do with my expression or limits within Workfront. Laura Manley Stream Companies
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

JustinRenteria2
JustinRenteria2
Level 6
November 16, 2018
Hi Laura, I don't believe that the ISBLANK function works with 2 values in it. You might want to try the && (and) qualifier. It would look a little something like this: IF(ISBLANK(choice 1) && ISBLANK(choice 3), CONCAT(choice 2) , ...... This reads: IF choice 1 AND choice 3 are blank then Concat choice 2 Hope it works for you! Justin Renteria SSFCU
    F
    FrancescaLeman
    April 17, 2023

    Hi All!,

     

    Do either of you know how to CONCAT 4 or more if statement values by chance? For example, IF(Choice 1=A&&Choice 2=B,"123",IF(Choice 1=C&&Choice 2=D,"456",N/A)) 

    I am using check boxes and trying to get all accurate values to show up in a calculated field, so for example is both if statements are correct I would like the calculated field to read "123, 456"

    L
    lauram26269131Author
    Level 2
    November 16, 2018
    Thank you! That seems to have worked. Laura Manley Stream Companies
    Terms & ConditionsAccessibility statement

    Loading footer...