2027 Goals Planner
Pick your goals for the year, break them into weekly actions and see where you stand every month.
File preview: click the tabs at the bottom to switch sheets
=SE(B4="";"";SE(H4<>"";H4;SE(NON(VAL.NUMERO(Mensile!P4));"Da iniziare";SE(Mensile!P4>=1;"Completato";SE(Mensile!P4>0;"In corso";"Da iniziare")))))| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | foglio=furboPlanner obiettivi 2027 | ||||||||
| 2 | Celle verdi: da compilare · grigie: calcolate (protette) · dati di esempio | ||||||||
| 3 | area | obiettivo | perche | valore_target | unita | scadenza | azione_settimanale | stato_manuale | stato |
| 4 | Soldi | Fondo emergenze | Dormire tranquilla | 3.000 | € | 31/12/2027 | 60 € ogni venerdì | In corso | |
| 5 | Salute | Correre 500 km | Più energia | 500 | km | 30/11/2027 | 3 uscite | In corso | |
| 6 | Crescita | Leggere 24 libri | Meno telefono la sera | 24 | libri | 31/12/2027 | 30 pagine al giorno | In corso | |
| 7 | Lavoro | Certificazione inglese B2 | Candidarmi a team lead | 1 | esame | 30/06/2027 | 2 lezioni | Fermo | Fermo |
| 8 | Casa | Svuotare la cantina | Spazio per la bici | 10 | scatoloni | 31/03/2027 | 1 scatolone | Completato | |
| 9 | Relazioni | Una cena con amici al mese | Vederci di più | 12 | cene | 31/12/2027 | 1 invito | In corso | |
| 10 | |||||||||
What's inside
| 1. Istruzioni | The steps to follow, what to fill in and what not to touch. |
| 2. Obiettivi | Up to 15 goals in 6 areas, with a manual status and a calculated one. |
| 3. Mensile | Value reached from January to December, latest value, % and a text progress bar. |
| 4. Dashboard | Average % per area, count per status, the area furthest behind, bar chart. |
| 5. Calendario | All 12 months of 2027 in a grid, with deadlines highlighted in green. |
Works with
Excel 2019 and Microsoft 365
Windows and Mac, .xlsx file. Formulas use Italian function names and the ; separator.
Google Sheets
Built in Sheets, not converted. "Make a copy" link, from your phone too.
No macros
No VBA or Apps Script to enable: it works as soon as you open it.
Tested before it's sold
Excel for Windows, Excel for Mac and Google Sheets. No errors on an empty file.
Questions about this template
Answers to the questions we get most often about the 2027 Goals Planner.
We reply within 2 working days.
Write to usWhat if I skip a month?
Nothing breaks. The last-value formula picks the latest month you filled in, even if you left one empty in between.
Can I set the status myself?
Yes. If you pick a status from the menu (for example "Fermo", on hold), your choice wins. Leave it empty and the status works itself out: "In corso" once there is progress, "Completato" at 100%.
How many goals can I add?
Up to 15, across 6 areas: work, money, health, home, growth and relationships.
Do the progress bars show up in Google Sheets too?
Yes. Instead of Excel's data bars (which Sheets doesn't have) they use a text bar built with REPT, so they look the same in both.
You might also need
"Organize 2027" Bundle
All 5 templates in one purchase: save €10.70.
2027 Leave and Attendance
Team holidays and leave, with 2027 public holidays and working days counted.
Expense Report
Trips, meals and mileage in an expense report that's ready to print.