Create beginner Works with: Any AI

Habit and Goal Tracker With Streaks

Table output Has example

Track habits with visual feedback.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Create a habit and goal tracker in a spreadsheet with streak calculations. Habits and goals I want to track: [HABITS_AND_GOALS]. Spreadsheet app: [SPREADSHEET_APP]. Period: [PERIOD]. How I want to see progress: [PROGRESS_PREFERENCE].

Return tables with the design:
1. Sheet layout: Sheet | Purpose | Key columns.
2. Habit grid: habits in rows, dates in columns, checkboxes or 1/0 entries; a data validation rule.
3. Formulas (written for my spreadsheet app) for: current streak, longest streak, completion percentage for the week and month, number of days missed in a row, and a flag when the streak is at risk.
4. Goals table: Goal | Measure | Start value | Target | Current | Percent complete | Deadline | Pace needed per week to hit the target.
5. Visuals: heat map via conditional formatting, a progress bar via data bars, and a weekly completion chart.
6. Reflection area: weekly notes and one change to try.
7. Design rules to keep it motivating: allow rest days, count "never miss twice" streaks, and track at most five habits.

Include sample data for 14 days and the expected results of each formula so I can test it. Avoid guilt-based design and explain the formulas in plain language.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Habit grid (excerpt): rows are habits, columns are dates.
Habit | Mon | Tue | Wed | Thu | Fri | Streak | Month %
Walk 20 min | 1 | 1 | 0 | 1 | 1 | 2 | 80%
Read 10 pages | 1 | 1 | 1 | 1 | 1 | 5 | 92%
Current streak formula idea: count consecutive 1s ending at the last filled date (a helper row that adds 1 if the day is 1, else 0). Longest streak = MAX of the helper row.
Goal row: Run 100 km | start 0 | current 34 | target 100 | deadline 31 Dec | pace needed 7.9 km/week.
Rules: allow one rest day a week; "never miss twice" status turns amber after one miss.

• habits
• tracker