A project tracker where the Gantt chart draws itself, and a task checklist that works out what's overdue, due today and due this week. No add-in, no macro, no shapes to drag.
A task list with a Gantt chart drawn entirely by conditional formatting — no shapes, no macros. Start and end dates make the bar, Done % fills it, Blocked turns it red, a line marks this week. Pro adds a 26-week timeline, a Dashboard, Milestones and a formulas walkthrough.
A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.
Most Gantt templates are shapes positioned by a macro; change a date and nothing moves. Stride’s bars are conditional formatting on a grid of weeks, so they follow the dates, fill with the Done percentage, turn red when blocked, and show a line on the current week. The three rules are on the Formulas sheet, and extending the timeline is copying a column.
The Pro Dashboard counts tasks by status, flags anything overdue, lists what’s due this week, and gives an overall progress figure weighted by task length. Per owner: open tasks and the days of work left. Milestones shows the dates that matter and how much of the phase behind each is done.
Tick is the other side of project work: a to-do list with an “as of” date. Every row compares its due date to it — Overdue, Today, Soon, Open — and a ✓ finishes it. Pro adds a Focus sheet that lists the overdue and due-this-week tasks by plain INDEX/MATCH (no FILTER, so Excel 2016 and Numbers are fine) and a Board of counts per category, person and priority.
The Tasks sheet with a 12-week Gantt and a credit line kept. Pro: 26 weeks, Dashboard, Milestones, Setup, formulas walkthrough.
Stride if tasks have a start and an end and you want to see them on a timeline. Tick if tasks have a due date and you want to know what's late — it's a to-do list with status, days left and a weekly Focus sheet.
Each week column tests whether its week overlaps the task's dates, and shades itself with conditional formatting. Three rules — planned, done, blocked — and a fourth for today's column. They're written out on the Formulas sheet.
Yes. Conditional formatting with custom formulas, data validation and the date functions used are all supported.
The task list with a 12-week Gantt and a credit line kept. Pro extends the timeline to 26 weeks and adds the Dashboard, Milestones, Setup and formulas walkthrough.