Creating a Milestone Sheet (referencing project plan)
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
Help Article Resources
Check out the Formula Handbook template!