Can a milestone task be closed based on completion of an approval task?

In each of my parent group of tasks I have an approval task, followed by a milestone task. Both are important for reporting.

Example:

Task1: Manager approves ABC Webpage for publishing

Task2: Milestone: ABC Webpage ready for publishing -

Predecessor for Task2 is Task1.

Problem: When Task1 is marked Complete, I want Task2 to automatically mark Complete as well.

Task2 required no implementation, it is for reporting of Milestones only.

Answers

  • John Shane
    John Shane ✭✭✭✭

    @DoraExplorer

    Are you using a check box or a symbol to show progress? If using the filled bar symbol, a formula like

    =IF(Task1 = "Full", "Full", "") in the symbol block of Task 2 where Task1 points to the symbol block for Task 1 (not sure what your column header is).

    If you are using check boxes, you can use

    =IF(Task1 = 1, 1, 0) with the same edits as above.

    Cheers,

    John

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!