# Google Sheets for project managers on Mac: trackers, timelines, and status updates in 2026

> Google Sheets for project managers on Mac: build a task tracker, a timeline without Gantt tools, and overdue flags. Steps for Chrome, plus Lazur.

URL: https://www.lazur.app/for/project-managers/google-sheets
Updated: 2026-11-08

Google Sheets works well for project managers on a Mac. It handles a task tracker, a simple timeline, and one shared file that several people can edit. You open it in a browser at sheets.google.com. This guide covers the tracker setup, a timeline built by hand, the formulas that flag overdue work, and the Mac shortcuts you use every day.

## Quick answer

- Open Sheets in your Mac browser at sheets.google.com. Start from a template or a blank file, then keep one task on each row.
- Google has no built-in Gantt chart, so build a timeline from a stacked bar chart with a Start column, a Duration column, and an End formula.
- Use a Status dropdown and a formula-based Overdue flag. Exact status text is what keeps counts correct.
- Use Option + / (Tool finder) when you know the command name but not where it lives. Use ⌘ + Option + = to insert rows above.
- Lazur helps while you work. Ask where a column is, get steps one click at a time, or dictate a status note. It does not click or edit for you.

Start with the job, not the template. Most project managers on a Mac use Google Sheets for three things. They keep a task tracker, draw a timeline, and report status to someone above them. Pick the one you need this week. The other two can wait.

## Google Sheets for project managers on Mac: setup first

Open Google Sheets at sheets.google.com in your browser. Google's help pages for Sheets point to the browser as the way in. No standalone Mac app from Google was confirmed for this guide, so treat the browser as your workspace.

Some guides describe a Chrome shortcut that opens Sheets in its own window. Those guides disagree on the menu path. Check Chrome's own menu for the option, and skip it if the steps do not match what you see.

Google's Template Gallery sits at the top right of the Sheets home page. Open a template and Google makes a copy, so your starting file stays clean. Google's help page notes that some template features only work with work or school accounts. Check that before you build a process around a template.

## Build a task tracker that stays readable

A tracker needs few columns. Start with Task, Owner, Start, Due, Status, Flag, and Notes, in that order. Keep one task on each row. Write each task name as a short phrase that starts with a verb.

- Task: one action per row, such as Confirm vendor start date.
- Owner: a name picked from one list, so you can filter by person.
- Start and Due: real dates, not typed text. Sorting and formulas need real dates.
- Status: a dropdown with a few fixed options.
- Flag: a formula that shows Overdue when needed. You never type in this column.
- Notes: free text for blockers, kept in the last column so the other columns stay in view.

Here is one row as an example. Task reads Confirm vendor start date. Owner is a name. Start and Due are real dates. Status reads In progress. The Flag cell stays blank until the due date passes and the task is still open.

Typed status words cause most of the trouble in trackers. In progress, In Progress with a trailing space, and WIP all look like status to a person. A formula counts only the text it matches, and one trailing space is enough to break a match. That is why the dropdown matters.

Make the Status column a dropdown. Select the column, then go to Data > Data validation. Add the options as a list, and use the same spelling everywhere. The [dropdown list guide for Chrome](https://www.lazur.app/how-to/create-a-dropdown-list-in-google-sheets) has the steps.

Freeze the header row so the column names stay visible as you scroll. Use View > Freeze > 1 row. The [freeze the top row guide](https://www.lazur.app/how-to/freeze-the-top-row-in-google-sheets) shows the browser steps. Sort by due date when you review, using the [sort by column guide](https://www.lazur.app/how-to/sort-data-by-column-in-google-sheets).

![Project manager on a Mac using Google Sheets for a task tracker at a desk](https://images.lazur.app/content-images/role-app/project-managers-google-sheets/google-sheets-for-project-managers-on-mac-1-491c67.jpg)

## Build a timeline without a Gantt button

Google Sheets has no built-in Gantt chart, according to Smartsheet's guide to Gantt charts in Sheets. Smartsheet sells project software, so weigh that view with care. The same guide says a basic Gantt chart can come from a stacked bar chart, and that Sheets handles simple versions well.

Put the timeline on its own tab. Use four columns: Task in A, Start in B as a real date, Duration in C in days, and End in D. In D2, type =B2+C2 and fill it down with ⌘ + d. Format column D as a date, so the end dates read as dates.

Select the Task, Start, and Duration columns together, including the header row. Go to Insert > Chart. In the Chart editor, choose a stacked bar chart. Remove the fill from the Start series, so only the duration bars show. The result looks like a simple Gantt chart.

> **Dependencies do not move on their own:** If one task slips, the tasks after it stay where they are. Smartsheet says Sheets dependencies do not update automatically. It also says Sheets has no automated workflows, so plan for manual checks at every schedule change.

Keep dependencies to one predecessor per task. Write the predecessor's ID in its own column, then test the lookup on a copy. A formula that points back at its own row creates a circular reference error. You will see that error the first time you change a date.

## Formulas that flag overdue work

Use TODAY() to compare due dates with the current date. In the Flag column, F, put this formula in F2 and fill it down: =IF(D2="","",IF(AND(D2<TODAY(),E2<>"Done"),"Overdue","")). Here D is Due and E is Status. Select the cells and press ⌘ + d to fill down.

The blank check matters. A blank due date counts as zero in a comparison, so without the check an empty row looks overdue. Test that with one empty row before you trust the column.

To count overdue tasks on a summary tab, use COUNTIFS: =COUNTIFS(D2:D200,"<"&TODAY(),E2:E200,"<>Done"). Set the range to cover every row you expect. Whole-column ranges such as D:D also work. Some guides blame them for slow sheets, so test on your own file.

> **TODAY() changes every day:** A report saved last week shows different counts when you open it today. Name the version under File > Version history > Name current version when you send a report, so the numbers stay on record.

Formula mistakes look fine at a glance. Check one overdue row by hand. Compare the flag with the due date and the status. Do this before each status meeting, not only the first time you build the sheet.

## Shortcuts for Mac keys you press all day

Google's keyboard shortcut page lists Mac shortcuts with ⌘ for Command and ⌥ for Option. Menu shortcuts on a Mac use Ctrl + Option. File, for example, is Ctrl + Option + f. Learn the handful below first, then look up the rest in the Tool finder.

| Task | Mac shortcut | When you use it |
| --- | --- | --- |
| Fill down | ⌘ + d | Copy a formula into the rows below |
| Fill right | ⌘ + r | Copy a formula across a row |
| Paste values only | ⌘ + Shift + v | Turn formula results into fixed values for a report |
| Insert rows above | ⌘ + Option + = | Add a task above the one you are on |
| Delete rows | ⌘ + Option + the minus key | Remove a task after you check what refers to it |
| Hide row | ⌘ + Option + 9 | Clear finished rows from view without deleting them |
| Tool finder | Option + / | Find any menu command by name |

_Mac shortcuts from Google's keyboard shortcut page, with when to use them._

The Tool finder was called Search the menus. Press Option + / and type the name of the action. It works well when you know what you want but not where it lives in the menus.

> **Paste values for reports:** Paste values only with ⌘ + Shift + v into the report tab. The report then stops changing when the live tracker changes. Keep the live tracker and the report in separate tabs.

![Office desk with a notebook and laptop, set up for project planning](https://images.lazur.app/content-images/role-app/project-managers-google-sheets/google-sheets-for-project-managers-on-mac-2-9c0fbd.jpg)

## Share the file and see who changed what

Several people can edit one Sheets file at the same time. Google's product page describes simultaneous editing, sharing permissions, and revision history. Open File > Version history > See version history to look back at earlier versions and who changed them.

Use [view only access](https://www.lazur.app/how-to/share-with-view-only-access-in-google-sheets) for stakeholders who should read, not edit. Give edit access only to the people who update their own rows. Share with the team, not the whole company, when the file holds budget or staffing details.

Lock the baseline. Select the range that holds the original dates, then go to Data > Protect sheets and ranges. Teammates can then change status without moving the baseline by mistake.

## Data limits to know before the file gets big

Google's Drive help page says a Sheets spreadsheet can hold up to 20 million cells or 100MB. Use that as the ceiling, and treat it as a hard limit rather than a target. Split the tracker long before you reach it.

- **20 million** cells per Google Sheets file, or 100MB, according to Google's Drive help page ([source](https://support.google.com/drive/answer/37603))
- **61%** of surveyed professionals use Google Sheets regularly, per Smartsheet's 2025 report ([source](https://www.smartsheet.com/content/hidden-cost-of-spreadsheets-report))
- **89%** of surveyed professionals use more than one tool to manage their work ([source](https://www.smartsheet.com/content/hidden-cost-of-spreadsheets-report))
- **45%** name manual updates as a top spreadsheet challenge ([source](https://www.smartsheet.com/content/hidden-cost-of-spreadsheets-report))

Connected Sheets has its own limits. Google's limits page says Connected Sheets pivot tables stop at 200,000 rows. Connected Sheets extracts stop at 500,000 rows or 5 million cells. Plan for those numbers if the tracker pulls from a large source.

Imports carry a catch too. Google's limits page says cells with more than 50,000 characters are removed when an Excel file converts to Google Sheets. Long notes fields are the most likely to hit that limit. Check them after every import. If you move files back out, the [download as Excel guide](https://www.lazur.app/how-to/download-as-excel-in-google-sheets) covers the steps.

## Where Google Sheets stops being enough

A spreadsheet fits a small project well. It gets harder when many projects share one file, when people need alerts, or when you report on workloads. Smartsheet's 2025 report surveyed more than 650 professionals, plus 16 in-depth interviews. The survey covers all professionals, not only project managers.

**Top spreadsheet challenges in Smartsheet's 2025 survey**

- Manual updates: 45 %
- Formatting issues: 36 %
- Undetected errors: 31 %

Source: https://www.smartsheet.com/content/hidden-cost-of-spreadsheets-report

The top challenges were manual updates at 45%, formatting issues at 36%, and undetected errors at 31%. Smartsheet also says teams spend more time maintaining their tools than using them to move work forward. It gives no percentage for that time.

The same report found 61% of respondents use Google Sheets regularly. It found 89% use more than one tool to manage work. Among teams that used spreadsheets without considering alternatives, 49% were generally satisfied. Among teams that adopted an alternative, 76% were. Smartsheet sells dedicated project software, so weigh those figures with that in mind.

## Google's AI features in Sheets, and how far to trust them

Google's Sheets product page says Gemini can build or edit a spreadsheet from a prompt. It also says Gemini can fill tables with Fill with Gemini, write formulas, and explain and fix formula errors.

The same page describes dashboards, heat maps, and Kanban boards built on your data without code. It lists connectors to Asana, HubSpot, Intuit QuickBooks, and Salesforce. These are Google's claims. This guide did not test them inside the app.

Test each feature on a copy of your file before you rely on it. Read every Gemini formula before you paste it. A formula you cannot explain is a formula you cannot defend in a status meeting.

## Use Lazur while you work in Sheets

Lazur is a voice assistant for the Mac that lives in the notch. Hold Option and Command to ask about anything on your screen, and Lazur answers out loud. Ask where a column is, and Lazur draws a circle and a label around it.

Ask how to do something, and Lazur guides you one click at a time. It waits for each click. Lazur does not click buttons, edit your sheet, or operate other apps for you. You keep your hands on the mouse and the keyboard.

Hold fn to dictate status notes at the cursor in any app. Dictation writes clean, formatted text where your cursor sits. Lazur also handles Apple Reminders, Calendar events, timers, and web search, so small tasks do not pull you out of the file for long.

Lazur listens and looks at your screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models. A budget sheet is still sensitive, so read the details before you ask about one.

> **What Lazur is not:** Lazur is not a plugin or add-in for Google Sheets or any other app. It works on your screen, outside the file. It runs on macOS, on Apple silicon and Intel Macs. Windows is planned, not available.

![Team gathered around a laptop during a project status meeting](https://images.lazur.app/content-images/role-app/project-managers-google-sheets/google-sheets-for-project-managers-on-mac-3-4cb2c2.jpg)

## Common mistakes project managers make in Sheets on Mac

- Typing dates as text. Text such as next Friday does not sort, and formulas skip it.
- Spelling one status three ways. The dropdown fixes this in one step.
- Deleting a row that other formulas point to. Check the references first, because a deleted reference can cause a reference error, shown as #REF.
- Keeping one file for both the team and the report. Copy the report out, then paste values only.
- Trusting a summary you have not checked. Test one row by hand before each status meeting.
- Letting one file grow forever. Split it by program or quarter once it starts to lag.

## A weekly routine that keeps the file honest

1. Filter the tracker to open tasks, then sort by due date.
2. Check the Overdue flags and the summary count against the rows.
3. Change status only through the dropdown. Do not type over it.
4. Copy the summary, then paste values only with ⌘ + Shift + v into the report tab.
5. Name the version under File > Version history > Name current version, then send the report.

Keep the routine short. A brief session on the same day each week beats a long one before a meeting. The file stays readable when the same steps happen each time, and the people reading it learn where to look.

## What to do next

Pick one live project this week. Build the tracker in a copy. Add the dropdown, the overdue flag, and the timeline, in that order. Then ask Lazur to point at anything you cannot find.

When you want voice help while you work, [download Lazur](https://www.lazur.app/download). The [pricing page](https://www.lazur.app/pricing) lists the plans, so you can compare them before you decide.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is the Due date column?”: Lazur draws a circle and a label around the Due date header, so you find it without scanning the whole sheet. (Points at it)
- “Where is the Status dropdown?”: Lazur circles the Status column header and labels it on screen.
- “Walk me through adding a dropdown to the Status column.”: Lazur guides you through Data > Data validation one click at a time, waiting for each click.
- “What does this #REF error mean in cell G4?”: Lazur explains that the formula points to a cell or row that no longer exists, and says where to check.
- “Draft a status note for the steering group from what is on screen.”: Lazur drafts a short status note from the visible rows. You read and edit it before you send it.
- “Dictate the risk note for the vendor delay.”: Hold fn and speak. Lazur types clean, formatted text at the cursor, in whichever cell you clicked.
- “Remind me Friday to send the budget review.”: Lazur adds an Apple Reminders item for Friday, outside the Sheets tab.
- “Research Google's limits for Connected Sheets pivot tables.”: Lazur runs the research in its own Chrome tabs and returns a summary and a report.

## FAQ

### Is there a Google Sheets app for Mac?

Google's help pages for Sheets point to the browser at sheets.google.com. No standalone Mac app from Google was confirmed for this guide. Some guides describe a Chrome shortcut that opens Sheets in its own window, but they disagree on the steps. Check Chrome's own menu first.

### Does Google Sheets have a Gantt chart?

Not a built-in one. Smartsheet's guide says Google has no built-in Gantt chart maker or prebuilt template. You can build a basic version from a stacked bar chart, using a Start column, a Duration column, and an End formula.

### How many cells can one Google Sheets file hold?

Google's Drive help page says up to 20 million cells or 100MB. Use that as the ceiling. Split the file well before you reach it, especially when several people edit the same sheet.

### Does Lazur work inside Google Sheets?

Lazur works on your Mac screen, in any app, including the browser where Sheets runs. It points at columns, guides you one click at a time, and dictates text. It does not click buttons or edit the sheet for you.

### Are there project management templates for Google Sheets?

Google's Template Gallery sits at the top right of the Sheets home page, and opening a template makes a copy. Smartsheet lists 14 project templates for Sheets, including a Gantt chart, a risk register, and a RACI matrix. That list comes from Smartsheet, not from Google's gallery.

### Why does my status count show the wrong number?

Look for spelling differences, extra spaces, and mixed names. A formula counts only the exact text it matches. Use a dropdown for the Status column, so every row uses the same options.

### Why is my tracker slow on my Mac?

Some guides blame volatile functions, conditional formatting, and whole-column ranges. Google's pages checked for this guide do not confirm those causes. Copy the file, remove one thing at a time, and test the speed after each change.

### Can I dictate into a Sheets cell with Lazur?

Yes. Click the cell first, then hold fn and speak. Dictation types clean, formatted text at the cursor. Dictation is unlimited on both the Pro and Power plans.

## Sources

1. [Keyboard shortcuts for Google Sheets: Google Docs Editors Help (Computer)](https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-08
2. [Use templates: Google Docs Editors Help (Computer)](https://support.google.com/docs/answer/148833?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-08
3. [Google Drive Help: file size and conversion limits](https://support.google.com/drive/answer/37603), Google, checked 2026-11-08
4. [Google Workspace: Google Sheets product page](https://workspace.google.com/products/sheets/), Google, checked 2026-11-08
5. [How to Make a Gantt Chart in Google Sheets](https://www.smartsheet.com/content/make-gantt-chart-google-sheets), Smartsheet, checked 2026-11-08
6. [Free Google Sheets Project Management Templates](https://www.smartsheet.com/content/google-sheets-project-management-templates), Smartsheet, checked 2026-11-08
7. [The Limitations of Spreadsheets: Smartsheet Original Research](https://www.smartsheet.com/content/hidden-cost-of-spreadsheets-report), Smartsheet, checked 2026-11-08