Creating a Milestone Sheet (referencing project plan)

Vin

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

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