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.

Find more posts tagged with

Formulas

functionality

Automations

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.