Calculated Field | If Then | Community
Skip to main content
M
MichelleFr2
Level 2
August 28, 2024
Solved

Calculated Field | If Then

  • August 28, 2024
  • 1 reply
  • 821 views

Hello All,

 

I have the calculated field below and the result I am getting is, it is showing me the L2, L3, & L4 levels. However, I want to see only L4, unless it is Blank then I want to see L3 and if that is Blank then for it show L2. What am I doing wrong?

 

CONCAT( {DE:admin | Calc L2 Organizations}, IF(ISBLANK({DE:admin | L3 Organization Lookup}),"",CONCAT(", ",{DE:admin | L3 Organization Lookup})), IF(ISBLANK({DE:admin | L4 Organization Lookup}),"",CONCAT(", ",{DE:admin | L4 Organization Lookup})))

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Lawson02

If I am understanding your question correctly: Show L4, If L4 blank show L3, If L3 blank show L2

IF(!ISBLANK(L4), L4, IF(!ISBLANK(L3), L3, L2))

1 reply

Lawson02
Lawson02Accepted solution
Level 6
August 28, 2024

If I am understanding your question correctly: Show L4, If L4 blank show L3, If L3 blank show L2

IF(!ISBLANK(L4), L4, IF(!ISBLANK(L3), L3, L2))

M
MichelleFr2Author
Level 2
August 28, 2024

Yes, so what you posted is what I need to update it to?

Lawson02
Lawson02
Level 6
August 28, 2024

Yeah I haven't tested it but the logic should be right. Let me know if it does not work

    Terms & ConditionsAccessibility statement

    Loading footer...