The signal

You do not need to become a programmer to make yourself more useful at work. Sometimes the valuable skill is smaller: turning a messy spreadsheet into something that tells people what needs attention.

AI assistants can draft spreadsheet formulas from ordinary language. That lowers the starting barrier for someone helping with a student society, working an office shift or supporting a small business. You can describe the result you want instead of knowing every function name first.

But producing a formula is not the same as producing a reliable spreadsheet. The useful skill is connecting three things: a clear rule, a working formula and an explanation another person can follow. That is a stronger contribution than pasting an answer you cannot check.

How it actually works

Start with a small question, not “make this spreadsheet better.” For example: Which unfinished tasks have passed their deadline?

In Google Sheets, create four columns: Task, Due date, Status and Flag. Use fictional tasks while learning. Enter due dates as actual dates, rather than descriptions such as “next Friday.” Keep the status labels consistent: Not started, In progress and Done.

Then ask an AI assistant:

“Write a Google Sheets formula for D2. Column B contains a due date and column C contains a status. If the status is Done, return Done. Otherwise, if the due date is blank, return Missing date. Otherwise, if the due date is before today, return Overdue. Return Upcoming for everything else. Explain each part and tell me what happens to a task due today.”

One formula that follows those rules is:

=IF(C2="Done","Done",IF(B2="","Missing date",IF(B2<TODAY(),"Overdue","Upcoming"))))

The order matters. A completed task stays Done even if its deadline has passed. An unfinished task without a date gets flagged instead of silently disappearing. A task due today counts as Upcoming under this particular rule—not Overdue.

Before filling the formula down the column, check it against a few rows whose answers you already know:

  • An unfinished task due yesterday should say Overdue.
  • A completed task due yesterday should say Done.
  • An unfinished task with no date should say Missing date.
  • An unfinished task due today should say Upcoming.

If your workplace treats today’s deadline differently, change the rule before changing the formula. Ask the assistant to explain the adjustment. A formula can be technically correct while answering the wrong business question.

Real example

Administrative assistants are a real example of workers who maintain records, prepare documents and help keep office work organised. A deadline tracker is a small practice project relevant to that work; it is not a claim that every employer uses this exact setup.

Imagine a fictional community workshop with tasks such as confirming a room, preparing name badges and sending reminders. ChatGPT can help draft the formula using just those column names and rules. It does not need the organisation’s actual spreadsheet, attendee details or internal notes.

That distinction matters at work. Use employer-approved tools and follow workplace data rules. Removing names alone may not make a file safe to upload.

The handoff is part of the skill, too. Add a short note explaining the accepted status labels and that “Upcoming” includes today. Because the formula uses TODAY(), flags can change as the sheet recalculates on later days. This is a live tracker, not a permanent record of yesterday’s status.

Your small move today

Spend 15 minutes building this tracker with six fictional tasks in a spreadsheet you already have access to. Use the formula above, check the expected results and write a two-sentence explanation beneath the table. No paid AI subscription is necessary for this exercise. Your finished artifact is modest but useful: a sheet you understand well enough to show someone else.

SOURCES
  1. 1OpenAI — Introducing ChatGPT
  2. 2U.S. Bureau of Labor Statistics — Secretaries and Administrative Assistants
  3. 3OpenAI — Terms of Use

Drafted with AI from trusted public sources and checked against our editorial rules. Educational content only — not personalized investment advice. Investing has risks and returns are never guaranteed.