Formula or method(s) for identifying project tasks that can be started

DW1

I have a project sheet with dependencies enabled. I am trying to build a report that shows tasks that can be started because all predecessor tasks have been completed (e.g., marked as 100% complete).

I have some ideas on how this can be accomplished, but wanted input from the community here, in case this problem has already been solved.

Thanks

David

JGreenberg

Hi David,

I use fully automated schedules that may help with your question. We have a Complete checkbox column that the team checks when a task is done (this is the only interaction we ask for from the larger team), and then a Status column (dropdown with Not Started, In Progress, Complete) that is entirely formula-based. Here is an example of a status formula for a row with Row 11 as a predecessor.

=IF(Complete@row = 1, "Complete", IF(AND(Complete11 = 1, Complete@row = 0), "In Progress", IF(Complete11 = 0, "Not Started")))

Then, we have automation workflows that send a "ready to start" transmittal to the person assigned to a row once the status changes to In Progress.

From there, you can create an In Progress report.

Hope this helps!

Jenna

Andrée Starå

Hi @DW1 @JGreenberg

I hope you're well and safe!

Have you explored using the SUCCESSORS feature instead?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!