Manipulation-Replacing parent if its parent is the child itself

[Sajjadmosaheb]

Hello everyone,

I am looking for a way to Replace the value of a parent cell if it has a parent itself.
for example, this is what I have:

and I want this:

I think this can be done by some if-rule statements.

Thanks in advance.

[lelloba]

Hello @Sajjadmosaheb ,

is this solution working for you?

Manipulation-Replacing parent if its parent is the child itself – lelloba

Have a nice day,
Raffaello Barri
LinkedIn

[Sajjadmosaheb]

Hi @lelloba ,
Thank you so much, Yes exactly what I wanted.

Best wishes,
Sajjad