Calculated Field | If Then

[WF_Admin_Dell_Tech]

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

[Lawson02 · Accepted solution]

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

[WF_Admin_Dell_Tech]

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

[Lawson02]

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

[WF_Admin_Dell_Tech]

It WORKED! THANK YOU!!!!!