I have a challenge for you… I have created a nested-projects Coda doc (using this brilliant post) that I hope to eventually use for my main project management sheet. Before that, I want to make sure some basic things are possible.
Can anyone figure out the formula to produce the desired sort order? It is logical, so I think there is a formula that outputs the numbers in the “DesiredSortOrder” column.
- Children must be (nested) under their parents.
- Projects on the same level are sorted alphabetically
Let me know if you have any questions!