Dear Community, I would appreciate your help. I am trying to assign a "parent" node for organization structure I have. I have columns ORGANIZATION and LEVEL, I need to create Parent column. I tried multi row formula but it doesn't work. ORGANIZATIONLEVELParentName110Name22Name1Name32Name1Name42Name1Name53Name4Name63Name4Name72Name1Name83Name7Name92Name1Name102Name1Name1110Name122Name11Name132Name11Name143Name13Name154Name14Name164Name14Name173Name13Name182Name11 Thank you in advance, Marcin

Creating a "parent" node

Dear Community,
I would appreciate your help. I am trying to assign a "parent" node for organization structure I have.

I have columns ORGANIZATION and LEVEL, I need to create Parent column. I tried multi row formula but it doesn't work.

Thank you in advance,

Marcin

Preparation

I was able to crack it. Here is how you can do it.

Workflow:

Hope this helps : )

This is what I was able to come up with.

Workflows

Hope this helps : )

Thank you for your feedback, it looks very interesting, however still doesn't work perfectly. In yellow I highlighted output different that expected:

Parent column:

Line 8 should be Name 7 (instead of Name4)

Line 12 and Line 13 should be Name11 (instead of Name1)

Line 14 should be Name13 (instead of Name4)

Do you have any idea?

Thank you,

Marcin

I was able to crack it. Here is how you can do it.

Workflow:

Hope this helps : )

This is exactly what I needed, many thanks!

Happy to help : ) @Javier070590

Cheers and have a nice day!