9 Google Sheets Formulas Every WordPress Lead Sheet Needs

Spreadsheets are error-prone. Up to 88% of audited spreadsheets contain errors, with an average cell error rate near 3.9% (Panko (2008)). A raw lead dump invites mistakes, manual counts, copy-paste typos, and duplicate rows nobody catches.

Formulas fix that. When your forms feed the sheet in real time, the right formula does the counting, lookups, and cleanup automatically. You stop maintaining the sheet and start reading it.

This guide assumes the rows arrive on their own. SheetLink Forms writes each WordPress submission straight to Google Sheets within a second or two, no Zapier task fees in between. Set up the feed once using our Google Sheets setup guide, then layer these nine formulas on top. Every example below works on a live, growing lead sheet.

ARRAYFORMULA solves the biggest problem with an auto-filled sheet, formulas that don't follow new rows. When SheetLink Forms appends a submission, a normal formula in column E only covers the rows you dragged it down to. ARRAYFORMULA applies your logic to an entire column at once, so row 5,000 gets the same treatment as row 5.

Put this once in the header cell of a helper column to combine first and last name across every row, present and future:

=ARRAYFORMULA(IF(A2:A="", "", B2:B & " " & C2:C))

The IF(A2:A="", "", ...) guard keeps empty rows blank so you don't get a column of trailing junk. Use the same pattern to normalize phone numbers, flag form types, or compute a lead age. One formula, zero maintenance, even as the sheet grows by hundreds of rows a week.

UNIQUE collapses repeated values into a clean list, which is essential when many leads share a company, a campaign, or a referrer. With Google Workspace used by 10M+ businesses (Google Workspace Blog (2025)), shared sheets are everywhere, and a tidy distinct list saves everyone from scrolling thousands of duplicate-looking rows.

To pull every distinct lead source that has ever appeared in column D:

=UNIQUE(Submissions!D2:D)

That single cell becomes a self-maintaining legend. The moment a form sends a new source value, it appears here automatically. Wrap it to feed a dropdown or a COUNTIF summary:

=SORT(UNIQUE(Submissions!D2:D))

UNIQUE is read-only, it never edits your raw data. Pair it with COUNTIF beside each value and you have an instant breakdown of volume by source, no manual category list to maintain as new campaigns launch.

TEXT converts a raw timestamp into a clean, readable date or a groupable label, which matters because form submissions arrive with full date-time precision. A raw value like 6/15/2026 14:32:09 is hard to group or read. TEXT reshapes it into exactly the format your reports need, and it never alters the underlying timestamp.

To show a friendly date from a timestamp in A2:

=TEXT(A2, "mmm d, yyyy")

To group leads by month for a trend report, strip the day entirely:

=TEXT(A2, "yyyy-mm")

That yyyy-mm output sorts correctly and feeds straight into a COUNTIF or pivot for monthly volume. Wrap it in ARRAYFORMULA to label every row automatically:

=ARRAYFORMULA(IF(A2:A="", "", TEXT(A2:A, "yyyy-mm")))

Clean date labels are the backbone of any time-series view, so this small formula does heavy lifting in the dashboards you build on top of the feed.

SPARKLINE draws a tiny inline chart inside a single cell, giving you an at-a-glance trend without building a full chart object. For a lead sheet that updates in real time, it's the simplest way to see whether submissions are rising or falling. There's no source statistic for charts, so treat this as a practical pattern: feed it a row of weekly or daily counts.

If cells B2:H2 hold the last seven days of lead counts, this draws a line trend:

=SPARKLINE(B2:H2, {"charttype","line";"color","#2563eb"})

For a volume-by-source bar in one cell, use the column variant:

=SPARKLINE(B2:H2, {"charttype","column"})

Place one SPARKLINE per source row beside its COUNTIF total and you get a compact dashboard, totals on the left, trend on the right. It refreshes the moment new counts roll in, so a live form feed becomes a live mini-chart with zero clicks.

These nine formulas only earn their keep when the rows arrive on their own. A formula-driven dashboard is useless if you're still pasting leads in by hand each morning. The whole point is a sheet that fills itself in real time, then reports on itself with QUERY, COUNTIF, UNIQUE, and SPARKLINE.

That's the gap most spreadsheet tutorials skip. They show you the formulas but not the ingestion. SheetLink Forms closes it by writing each WordPress submission directly to Google Sheets, no middleware, no per-task fees like Zapier's metered model (Zapier pricing (2026)). The free version on 17 supported form plugins handles the feed; the formulas above handle the rest.

If your team is moving toward Microsoft 365, the same formula thinking applies. Excel Online and Google Sheets both support QUERY-style logic, and SheetLink can deliver to Excel too. Start with the feed, then build the live tracker your sales team will actually open every day.