Help with array formula

[simonhelps]

Hi,
I have an app connected to google sheets and I am having trouble with a formula that I was creating in a column inside sheets. I can get it to work on a row basis but not as an array.
This formula works on a row basis:-
=countunique(iferror(filter(temp!$B$2:$B, A2=temp!$O$2:$O)))

but when I put it inside an array it works but only returns zero’s:-
=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(A2:A4392="","",countunique(iferror(filter(temp!B2:B, A2=temp!O2:O))))), 4391, 1)

Any help is appreciated!
I second question out of interest is how would I create the same information within appsheet instead of coding it direct into sheets?
THanks in advance

[scott_robinson]

I’m just wondering if you’ve left out an array in your formula?

=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(A2:A4392="","",countunique(iferror(filter(temp!B2:B, A2=temp…at this point, shouldn’t the A2= be A2:A=temp

[simonhelps]

simonhelps:

=countunique(iferror(filter(temp!$B$2:$B, A2=temp!$O$2:$O)))

Hi Scott, That doesn’t make it work either. I still just get zeros returned. Thanks for looking at it.

[Steve]

This is a Google Sheets question, not an AppSheet question. Please take it to a more appropriate forum.