iDel Build a Goal Tracking Spreadsheet with Useful Formulas
Build a Goal Tracking Spreadsheet with Useful Formulas
A useful goal tracker answers three questions: what are you trying to finish, what happened this week, and what needs to change next? Start with two sheets, Goals and Sessions. Add a weekly review note before adding charts. This setup suits a personal project with a few measurable milestones and scheduled work sessions.
The worked example below follows a portfolio project. You can copy its columns into Google Sheets and replace the sample entries with your own. The formulas use English function names and commas; spreadsheets configured for another locale may require different separators. Keep a separate copy before experimenting with formulas or importing old records.
1. Define the result on a Goals sheet
Create these columns: Goal, Completion evidence, Target date, Next milestone, Status, and Next action. Give each goal a short stable name so you can recognize it in the session log. Write the target date as a complete date, including the year.
For the portfolio example, the completion evidence is three published case studies with working links, image descriptions, and a saved backup. The next milestone is a complete draft of the first case study. The next action is to collect the project brief and approved screenshots in one folder.
Use a small status vocabulary such as Planned, Active, Waiting, Complete, and Paused. Define Waiting as a specific external dependency and record who needs to respond. A row marked Complete should include a link or location for the finished work. That makes the tracker useful when you return to it months later.
2. Log planned sessions separately
On Sessions, use this layout. One row represents one planned session. Add extra completed sessions as separate rows and mark them as additional work in Notes, so your review can distinguish them from the original commitment.
| Column | Header | Example entry |
|---|---|---|
| A | Date | The scheduled date |
| B | Goal | Portfolio |
| C | Plan | Planned |
| D | Result | Done |
| E | Minutes | 60 |
| F | Evidence or note | First case study outline saved |
In C, enter Planned for the sessions you intend to undertake. In D, use Done, Missed, or leave the cell blank while the session is still in the future. Keep cancelled sessions visible with a note explaining the changed plan. If you remove them from the planned count, record the change in the weekly review so the original commitment is still understandable.
For an initial week with four planned sessions and three completed sessions, the completion rate is 3 divided by 4, or 75%. Record the missed session and its reason. A blank result means you have not yet entered the outcome; it is different from a deliberate Missed entry.
3. Add counts you can check by hand
For a sheet whose first week occupies rows 2 through 8, these formulas count the planned and completed entries:
=COUNTIF(C2:C8,"Planned")
=COUNTIF(D2:D8,"Done")
=SUM(E2:E8)Google’s documentation describes COUNTIF as a conditional count and SUM as an addition function. Here the ranges are deliberately short so you can inspect every included row. Put the formulas beside the table, label their results, and confirm that three Done entries return 3 before relying on the totals.
The second formula counts all completed sessions in the range. If you also log extra sessions, count only completed planned sessions for the planned-session rate. One straightforward approach is to keep extra work in a separate block below the weekly range. You can still add its minutes to a separate total for all work.
Place the planned count in H2 and the completed planned count in H3. The rate formula in H4 is:
=IF(H2=0,"",H3/H2)Format H4 as a percentage. With no sessions planned, it remains blank instead of displaying a division error. With three completed out of four planned, it should display 75%. If a result exceeds 100%, inspect whether additional sessions were included or a planned entry was omitted.
4. Track the quality of the output
Session counts describe attendance. Add evidence about the work itself: a draft, a solved exercise, a reviewed design, or a published page. For the portfolio project, a three-item checklist might cover a clear problem statement, supporting images with permission, and a description of the decisions made.
A productive review can show four completed sessions but an unfinished milestone. Read the notes to learn why. Perhaps the source materials were missing, the scope expanded, or the work needed more revision than expected. Adjust the next action or the time estimate rather than changing the meaning of Done to make the percentage look better.
5. Keep a short weekly decision log
Below the Goals table, record the review date, finished work, obstacle, decision, and next checkpoint. This preserves the reason behind a change. “Move case study two to next week because image permission is pending” is more useful than a status cell that simply turns red.
Compare the actual minutes with the scheduled time. If three sessions took 60, 45, and 75 minutes, the total is 180 minutes, or three hours. Use that experience when planning a comparable task. Separate time spent learning an unfamiliar tool from the time spent producing the deliverable; the next project may need a different estimate.
Our weekly review guide provides a review sequence, and the quarterly planning guide explains how to connect milestones to available time.
6. Preserve the records without making upkeep a project
At the end of a planning cycle, duplicate the workbook or export a backup before clearing any rows. Name it with the project and date. Open the saved copy once to check that the information you need is present. If you use a CSV export, remember that a CSV is a single table of values: keep the original workbook for multiple sheets, formatting, and formulas.
Share only the information another person needs. A collaborator may need milestone dates and links to approved work, while your private notes contain unrelated commitments. Keep those in a separate document or file rather than assuming a hidden sheet is a privacy boundary.
Begin with the two sheets and one week of real entries. After the review, remove columns that did not help you make a decision. Add a chart only when it answers a recurring question, such as whether the available weekly hours match the remaining scope. The spreadsheet earns its place by helping you choose the next action.