Organization chart calculation

Question

Hi All,

In my data I need to provide start ID and end ID for each manager and its dependent. For a manager Node 0 and its dependent Node 1.1  and Node 1.2, the start ID will be 1 and end ID will be 2 and 3. For manager Node 1 and its dependent Node 1.1 and Node 1.2, the start ID is 2 and end ID is 4 and 5. Could you please help me on the same.

Input file:

Output file:

Regards,

Shikha

Christina_H · Answer

This provides a unique ID for each node, but they aren't the same as yours due to ordering.  If you need the exact numbers you've stated you'll need to order them appropriately before numbering.

OrgChart.yxmd

sshivani · Answer

Thanks David.

The multi-row formula is not working when my data level increases. For e.g. in the below screen shot for Manager Node 1.1.1 the start id should be "9" however, here it is coming as "5".

Regards,

Shikha

David-Carnes · Answer

@sshivani 
Use a Multi-Row Formula tool.

4 sshivani.yxmd