Formula Solutions
Solve everyday problems, from overnight shifts to reporting, with step-by-step formulas.
Count records that meet multiple criteria
Use COUNTIFS to count open tasks at a selected location.
Find an employee name by employee ID
Look up the employee ID using an exact match and return the name from the same row.
List shifts by location
Choose a location. FILTER lists the corresponding shift rows in a separate output area.
Flag overdue tasks
Flag a task when its due date is before today and its status is incomplete.
Flag stock for reorder
Flag an item when on-hand quantity reaches or falls below its reorder point.
Calculate hours for a shift that crosses midnight
Enter the start and end as dates and times, then subtract the break. A 22:00–06:00 shift with a 30-minute break lasts 7 hours and 30 minutes.
Compare planned and actual working hours
Subtract planned net work time from actual net work time. A shift planned for 480 minutes that takes 510 minutes runs 0.50 hours, or 30 minutes, over plan.
Sum working hours by team and month
Use SUMIFS to total net hours for a selected team in a given month. In the example, the Warehouse team worked 15 hours and 30 minutes in November 2026.