How to Manage Multiple Projects: A Simple Weekly System

Here is how to manage multiple projects without dropping any: put every project on one master list, review that list for 30 minutes once a week, and check that the hours your projects need fit the hours you actually have. Give each project a status color that triggers a clear action, and when the numbers do not fit, move a date, hand something off or say no.

Once the list exists, the whole system takes about half an hour a week. Below are the five habits, with a worked capacity check you can copy.

Why Juggling Multiple Projects Gets Hard

The trouble rarely comes from one project. It comes from the gaps between them: a commitment that lives only in an email, four projects all marked urgent, a week that was full before a new request landed. Every switch between projects also costs time while you remember where you left off.

The habits below close those gaps. One list means nothing hides. A weekly review means problems surface while there is still time to act. A capacity check turns “I feel swamped” into a number you can discuss. Status colors tell you where to look first, and a clear way to say no protects the work you already promised.

How to Manage Multiple Projects From One Master List

Every project gets exactly one row on one list, including internal projects that never send an invoice, because they use the same hours. The detailed tasks for each project live in that project’s own task list. The master list stays short enough to read in a minute.

Column	What goes in it	Example
Project	A short name everyone uses	Clinic website
Owner	One person, even on a team	Ana
End date	The date that matters to the client	Oct 23
Next milestone	The next checkpoint and its date	Homepage design, Oct 9
Next action	The very next concrete step	Email the clinic for photos
Hours left	Your best estimate of remaining work	36
Status	Green, amber, red, on hold or done	Amber

The next action column does the most work. If you cannot write one for a project, that project is stalled, and you have found your first problem. Keep actions physical and small: “Email the clinic for photos” rather than “Sort out images.”

A spreadsheet tab is the easiest home for the list, since you can sort by end date and total the hours. If you would rather not build it, our multiple project tracking template keeps one row per project with dates, days left, owner, priority, progress and status, plus budget and profit. Routine work such as weekly reports or invoicing is not a project, but it eats the same hours, so track it separately with the method in how to manage recurring tasks.

Run a 30-Minute Weekly Portfolio Review

Pick one fixed slot, such as Friday afternoon or Monday morning, and run the same agenda every time:

1. Collect (5 minutes). Sweep your inbox, notes and chat for new commitments and add each one to the list as a row or a task.
2. Update every row (10 minutes). Refresh the end date, next milestone, hours left and status. For ways to put a real number on progress, see how to track project progress.
3. Check capacity (5 minutes). Total the weekly hours your projects need and compare them with the hours you have (the next section shows how).
4. Decide (5 minutes). For every amber or red row, make one decision: a new date, more help, less scope or a pause.
5. Plan the week (5 minutes). Choose the two or three projects that get your focus blocks and put those blocks in your calendar now.

On a team, owners update their own rows before the meeting, and the meeting only discusses amber and red projects. Green projects get skipped, which keeps the review short.

Check Your Capacity in Hours

Capacity is the step most people skip, and it is the one that explains why a week feels impossible. Start with your hours for project work: your working week minus meetings, email, admin and recurring tasks. Then work out what each project needs per week: hours left divided by weeks left, counting the current week as one.

Here is a designer’s list on Monday, October 5, 2026. She works 40 hours, and 12 go to meetings, email and admin, which leaves 28 hours for projects.

Project	Hours left	End date	Weeks left	Hours per week
Clinic website	36	Oct 23	3	12
Bakery brand refresh	20	Oct 16	2	10
Annual report	24	Oct 30	4	6
Newsletter setup	8	Oct 9	1	8
Portfolio update (internal)	15	Nov 6	5	3
Total				39

The projects need 39 hours a week and she has 28: 11 hours over, a load of 139%. No single row looks unreasonable, which is exactly why the problem stays invisible until you add them up. Three changes bring it back in line:

• Pause the internal portfolio update until the clinic website ships: 39 minus 3 leaves 36 hours.
• Ask the annual report client for November 13 instead of October 30. The same 24 hours over 6 weeks is 4 hours a week, saving 2: now 34.
• Hand the newsletter setup to a colleague, keeping 1 hour to review it, saving 7: now 27.

The new load is 27 of 28 hours, or 96%. That is tight but workable for the two weeks until the bakery refresh ships. Anything above 100% is a plan that cannot happen, and running close to 100% for months leaves no room for the surprise that arrives most weeks.

To automate it on the master list above (end date in column C, hours left in F), put this in H2 in both Google Sheets and Excel:

=F2/MAX(1, ROUNDUP((C2-TODAY())/7, 0))

Then =SUM(H2:H20)/28 gives your load, with 28 replaced by your own project hours.

Use Status Colors That Trigger an Action

A color is only useful if everyone knows what happens next. Keep the set small:

Color	What it means	What happens at the review
Green	On track for date and budget	Nothing. Skip it.
Amber	At risk, but the owner has a recovery plan	The owner states the plan and when it will be green again
Red	Will miss the date or budget without a decision from someone else	Decide today: new date, more help, less scope or a pause
Gray	On hold on purpose	Give it a restart date or close it

Three rules keep the colors honest. The owner sets the color, not the manager. Red is information, not a failure, so nobody should be afraid to use it. And a project that stays amber for three reviews in a row is red, because the recovery plan is not working.

To color the rows automatically, select the list and add a conditional formatting rule with a custom formula such as =$G2="Red", one rule per color. In Google Sheets it is Format > Conditional formatting > Custom formula is. In Excel it is Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.

How to Prioritize Multiple Projects

When every project claims to be the top priority, rank them in this order:

1. Fixed external deadlines with a real cost if missed: a launch date, an event, a filing deadline.
2. Projects other people are waiting on. An hour you spend unblocking a colleague is worth more than an hour on your own queue.
3. Value per remaining hour. A $2,000 project with 10 hours left returns $200 per hour of your time. A $3,000 project with 40 hours left returns $75.
4. Everything else, including internal projects, in end-date order.

Then limit how many projects are active at once. Two or three in progress per person, with the rest queued with a start date, beats eight projects all moving slowly. The same idea drives work-in-progress limits in personal kanban. For ranking methods such as MoSCoW or ABCDE, which work for projects as well as tasks, see how to prioritize tasks.

When to Say No to a New Project

Saying no, or “not now,” is part of managing a portfolio, not a failure of it. Decline or defer a new request when:

• your capacity check is already above 100% and the new project has no fixed date;
• taking it on would push a red project further back;
• nobody can name the owner or the end date;
• it does not connect to a goal you or your team agreed on;
• its value per hour is lower than everything already on your list.

The word no is easier to say when it comes with an option. A few ways to put it:

• To a client: “I can start on November 2 and deliver by November 27. If you need it sooner, I can recommend someone who has room now.”
• To a manager: “I can take this on if the annual report moves to November 13 or the newsletter goes to Sam. Which would you prefer?”
• To yourself: add the idea to a “later” list with the date you will look at it again, so it stops nagging you.

Handing work off is often the better answer than refusing it. Our guide on how to delegate tasks covers what to hand over and how to follow up without taking it back.

Before you close this page, book the weekly review as a recurring 30-minute appointment with yourself. The first one takes longer while you build the list; after that, it is mostly updating rows.