Automatic Parent/Child Assignment

In my organization, we have ID numbers for tasks. They go something like this:


Top Level: AB

Second Level: ABcde

Third Level: ABcde1

Fourth Level ABcde1.1

Where ABcde1.1 is the child of ABcde1 which is the child of ABcde which is the child of AB.

Is there anyway to automate the parent/child relationships based on the value of a column such as this ID?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!