=ArrayFormula({"test"; IF(AND(Q2:Q="true", R2:R="true"), "match", "")})
For some reason I am only getting a value in row 2. Am I missing something?
>Solution :
can you try either & see if it works:
=ArrayFormula({"test"; IF((Q2:Q=TRUE)*(R2:R=TRUE), "match", "")})
OR
=ArrayFormula({"test"; IF((Q2:Q="true")*(R2:R="true"), "match", "")})