Creating a Milestone Sheet (referencing project plan)

Hi All,

I have created a project plan in Smartsheets and am tracking milestones using tags

How do I create a separate sheet which only shows me milestones, its start/finish (i.e start=earliest start date with a particular tag, and end=latest end date with a particular tag), its % completion (based on the milestone tag) and its health.

For example, I use tags milestone1, milestone2, milestone3 etc. against my main project plan and the new spreadsheet shows me the following

Tag: %Completion Start Finish

Milestone1 95% 3/1/22. 6/1/22

Milestone2 60% 3/15/22. 8/1/22

Find more posts tagged with

Sheets

Formulas

Support

functionality

Project Management

Accepted answers

All comments

Paul Newcome

I would suggest creating a report that is filtered based on the tag containing "milestone".

Vin

Thank you Paul,

Smartsheet team helped me achieved this by creating a metric report and using formulae to capture earliest start date for a given milestone tag and latest end date for a given milestone tag.

Vin

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.