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

Options

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

Answers

  • JGreenberg
    Options

    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å
    Andrée Starå ✭✭✭✭✭✭
    Options

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!