Google Sheets formulas for jobs people search by task.
QUERY paid rows, fill a column with ARRAYFORMULA, pull another file, build a unique dropdown, and group totals.
QUERY paid rows
Google Sheets QUERY Paid Rows Formula
QUERY can select, filter, and sort in one formula. Keep the status column as consistent text.
Read guide- Fill a columnGoogle Sheets ARRAYFORMULA Fill a ColumnOne formula can return a whole column. Leave the cells below empty so the array can expand.
- IMPORTRANGEGoogle Sheets IMPORTRANGE Another FileIMPORTRANGE copies a range from another file after you click Allow access. The URL and sheet name must be exact.
- Unique dropdownGoogle Sheets Unique List for DropdownsUNIQUE spills distinct values. SORT makes the dropdown readable. FILTER drops blanks so the list stays clean.
- QUERY group totalsGoogle Sheets QUERY Group By TotalsQUERY group by returns one row per category with an aggregate. Label the sum so the header is readable.
Need this on your tabs?
Describe the sheet. Copy a Google Sheets formula with the right dialect.