Hello!
I’m looking to see if anyone has any knowledge or experience using formulas to trigger dependencies based on specific timelines.
For example I have a board with 5 groups, and most of the Tasks have basic dependencies where they are triggered from Waiting to Start to Ready to Start. Then there are some Tasks that need to be unblocked after a specific point of time after a task is marked complete.
So if Task A is marked complete Task B should be changed to Ready to start one week after the status of Task A is changed to complete.
I thought this could be completed with formulas but without specific dates (as I’m building this as a template) and formulas don’t really change statuses the same way the Dependency column does.
If anyone has any advice it’d be greatly appreciated!