Is it possible to create uniquely identified numbers using level 1 parent tasks as a baseline?
Is it possible to pull the first three letters of a parent task, and then give it an unique identifying number xxx-9999?
I have groups of tasks that I would like to create an ID for whenever there is a newly created line, each line would inherently be a child to parent task. For example a subtask of an "Engineering" group might read:
Right now I have the parents nested in a [Task] column, it would be great to have some logic surrounding if it is, or is not a level 1 parent, so it doesn't automatically number parent tasks.
Help Article Resources
Check out the Formula Handbook template!