Formula templates
Pick a starter — we'll fill in your request so you can run it right away.
Totals & sums
- Add up paid rows onlyPro
Sum amounts when a status column says paid.
- Running total down a columnPro
Cumulative sum as you go down the sheet.
- Average ignoring blanksPro
Average of a column skipping empty cells.
- Each row as % of totalPro
Show share of the whole column.
- Highest value per categoryPro
Max within each group.
- Combine first and last namePro
Join text from two columns.
Lookups
Counts & unique
Dates
Errors & fixes
Business trackers
- Budget tracker with category totalsPlus
Track spending by category with monthly totals.
- Invoice tracker — unpaid listPlus
Track invoices, due dates, and unpaid totals.
- Inventory tracker with low-stock alertPlus
Track stock levels and flag items below a threshold.
- Sales dashboard by rep and monthPlus
Summarize sales by salesperson and month.
- Real estate lead trackerPlus
Track leads, follow-ups, and deal status.
- Client follow-up CRMPlus
Track clients, last contact, and next follow-up.
- Expense trackerPlus
Log expenses with categories and monthly totals.
- Subscription trackerPlus
Track recurring subscriptions and renewal dates.
- Project task trackerPlus
Tasks, owners, due dates, and status.
- Small business KPI dashboardPlus
Key metrics at a glance.
- Content calendarPlus
Plan posts with dates, channels, and status.
- Payroll hours helperPro
Sum hours and calculate pay.
Personal & home
- Habit trackerPlus
Daily habits with weekly summary.
- Grade trackerPlus
Track assignments and calculate averages.
- Meal plannerPlus
Weekly meals with shopping list.
- Cleaning schedulePlus
Recurring chores by room and frequency.
- Remove duplicate rowsPlus
Keep first occurrence of each duplicate.
- Split full namesPlus
First name and last name from one column.