Skip to content
Workflow · Track and forecast · Opening soon

Airtable status report by owner

Export your projects from Airtable as a spreadsheet file, then upload it to Mammoth. Map the fields for owner, status, due date, and last updated date, and Mammoth builds the report for you.

Early access opens shortly. Check back soon.

Someone typed

“turn our airtable projects base into a status report: projects by owner and status with how many are overdue, and flag projects past their due date that are not done, projects with no owner, and projects not updated in thirty days”

The agent read it as

Turn Airtable Projects into a status report: projects by owner and status with how many are overdue, and flag projects past their due date that are not done, projects with no owner, and projects not updated in thirty days.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Airtable Projects
    CSV export · 40 rows
  2. Step
    Flag project status
    Step 1
  3. Result
    Project Status Report
    40 rows
  4. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 40 rows.

What you get back

The result of that run, the rows to look at first.

Project Status ReportSample data40 rows
ProjectOverdue countOverdue flagOwner flagUpdate flagOwnerStageDue DateLast Modified
Product Launch Sprint1Overdue··Avery BrooksBlocked2026-10-292026-11-16
Board Packet Design0··Not updated in 30 daysCaleb StoneIn progress2027-03-182026-09-29
Sales Deck Polish1Overdue··Ethan ColeBlocked2026-10-312026-11-12
Social Launch Assets1Overdue··Ethan ColeIn progress2026-10-052026-11-17
SEO Content Refresh1Overdue··Lena OrtizBlocked2026-10-182026-11-13
Customer Journey Map0··Not updated in 30 daysLena OrtizIn progress2027-02-142026-08-28
Inventory Sync Spec0··Not updated in 30 daysOwen ParkIn progress2027-01-272026-09-05
Podcast Promo Cut1Overdue··Priya NairBlocked2026-10-222026-11-18
Studio Rebrand0··Not updated in 30 daysPriya NairIn progress2027-05-072026-10-12
Ad Library Audit1Overdue··Zoe BennettBlocked2026-11-082026-11-18
Partner Onboarding Kit0·No owner··Blocked2027-01-202026-11-15
Demand Forecast Model0·No owner··In progress2027-02-162026-11-18
40 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Project Status Report workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Project Status Report: questions

How do you create Airtable reports by owner?
Export your projects from Airtable as a spreadsheet file, then upload it to Mammoth. Map the fields for owner, status, due date, and last updated date, and Mammoth builds the report for you. It groups projects by owner and status, counts overdue items, and flags projects that are past due but not done, have no owner, or have not been updated in thirty days.
What Airtable export should you use?
Use a file export of the table that contains your project records. Include the columns you need for the report, usually owner, status, due date, and last updated date.
What happens to rows that do not match the rules?
Rows that do not meet a flag rule are kept in the report, but they are not marked for that rule. If a row is missing a needed field, it may not be grouped or flagged the way you expect.
How do you change the rules?
Edit the rule words in the workflow, for example, which statuses count as done, how long counts as stale, or which fields to use for owner and due date. Then run the report again on a fresh export.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.

All track and forecast workflows →