The team at our company do not do things in order according to the Timeline or their Dependencies.
I had an automation which changed the Status to Ready to Start when the Dependency was Done.
The issue with this, is that if someone has already changed the Status to Done on an Item further down the board, the automation changes this Done status back to Ready to Start.
Is there a Formula I could use, which says that if the Status is already Done, do not change it?
I am just wondering if the Formula column could help me with this as all other ways of doing it causes a lot of manual hours which defeats the whole purpose of Monday.com.