Skip to main content
Level 2
Aug 28, 2024 7:17 PM UTC
Solved

Calculated Field | If Then

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.
Lawson02
Lawson02Accepted solution
Level 6
Aug 28, 2024 9:13 PM UTC

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

4 replies

Lawson02
Lawson02Accepted solution
Level 6
Aug 28, 2024 9:13 PM UTC

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

Translate
Level 2
Aug 28, 2024 9:18 PM UTC

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

Translate
Lawson02
Level 6
Aug 28, 2024 9:29 PM UTC

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

Translate