A Google Sheets address book where each contact row has a WhatsApp icon that opens the chat in WhatsApp Web and an Email icon that starts a new message. See the columns, how the links work and the HYPERLINK formulas behind them.
Google Sheets
Inventory Management and Profit Analysis Dashboard in Google Sheets
A four-tab Google Sheets template that logs purchases and sales, looks up prices from a product master and shows sales, purchase, profit, Profit% and stock for any date range. See every tab, the formulas and a worked example.
Sales KPI Dashboard in Google Sheets
A ready-made Sales KPI Dashboard in Google Sheets with five slicers, Gross Sales, Discount, Net Sale, COGS and Profit cards, and charts by month, country, segment and product. See how each part works and how to load your own data.
Magic Search Box in Google Sheets (FILTER Formula)
Build a magic search box in Google Sheets with one FILTER formula: choose a field, type a keyword and see matching rows with live totals. Includes syntax, a worked example and variations.
Attendance Sheet Template in Google Sheets (Monthly)
A monthly attendance sheet template in Google Sheets with P, L, A and WO dropdowns, automatic present/leave/absent counts and team totals. See the layout, a worked example and the formulas.
Multi-Location Inventory Management in Google Sheets
Track stock IN, stock OUT and transfers across four warehouses in Google Sheets, with closing stock and stock value for any date. See each tab, a worked example and the formula logic.
Dynamic Calendar with Holiday and Events in Google Sheets
Build a dynamic calendar with holidays and events in Google Sheets: a year dropdown, SEQUENCE and LET month grids, and COUNTIF conditional formatting that highlights every listed date.
Inventory Management System in Google Sheets (Free Template)
Track stock in and out, see closing balances for any date and get reorder alerts with a free four-tab inventory management system in Google Sheets, with the formulas explained.