I found through different template a really convenient formula to facilitate my tasks management. It allows me to order them very easily based also on dependencies.
I have a huge tasks table (Tasks) and a column in it (Dependency) that reference the task table itself and I added the formula as per the following screenshot
While making my table super easy to order it also slow it down considerably whenever I had a new task because it calculate the entire thing again. I have approximately a thousand rows in my table
Do you have any ways to optimise this formula while keeping the same format?
Thank you very much,