Creating a "parent" node

[Javier070590]

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.

ORGANIZATION	LEVEL	Parent
Name1	1	0
Name2	2	Name1
Name3	2	Name1
Name4	2	Name1
Name5	3	Name4
Name6	3	Name4
Name7	2	Name1
Name8	3	Name7
Name9	2	Name1
Name10	2	Name1
Name11	1	0
Name12	2	Name11
Name13	2	Name11
Name14	3	Name13
Name15	4	Name14
Name16	4	Name14
Name17	3	Name13
Name18	2	Name11

Thank you in advance,

Marcin

[atcodedog05]

Hi @Javier070590 

This is what I was able to come up with.

Workflows

Hope this helps : )

[Javier070590]

Hi @atcodedog05,

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

[atcodedog05 · Accepted solution]

Hi @Javier070590 

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

Workflow:

Hope this helps : )

[Javier070590]

Hi @atcodedog05,

This is exactly what I needed, many thanks!

[atcodedog05]

Happy to help : ) @Javier070590 

Cheers and have a nice day!