Is there an automation or a way to use the Auto Number column to automatically create dependencies based on the order of the items. So the item that comes after another item in a group would be linked to the item above.
Ideally if an item would be moved to a new spot in the group, the Dependency column would update just as the Auto Number column does.
Otherwise with the quantity of new groups that are added on a daily basis, along with some very similar subitem tasks, at my company makes adding dependencies a very time consuming task.
Any help would be greatly appreciated, thanks!