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
-
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
Categories
Check out the Formula Handbook template!