Google Sheets ARRAYFORMULA with IF
ARRAYFORMULA+IF patterns that auto-fill Google Sheets columns as new rows appear.
Read articleGoogle Sheets QUERY: SELECT and WHERE Formula
Google Sheets QUERY examples for WHERE filters, ORDER BY, GROUP BY, and dates.
Read article