Where B6 = % complete from Dashboard.
| A | B | C | D | |---|---|---|---| | | My Project | Start Date | 01-Jan-2026 | | Project Manager | Your Name | End Date | 31-Mar-2026 | | Total Tasks | =COUNTA(Tasks!A:A)-1 | Completed Tasks | =COUNTIF(Tasks!E:E,"Done") | | Completion % | =IFERROR(B5/B4,0) | On Track? | =IF(B6>=0.75,"✅ Yes","⚠️ Review") | project management excel template
: