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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!