Array works in excel but not in google sheets

[mrjinx007]

Hi,
I have an array that looks at column A-3 through A-245 and displays cells that are not empty. Converted the form to google sheets and although it converts the formula, it does not work.
Any help is greatly appreciated.

 

[Fluff]

You mean this
=FILTER(A2:A37,A2:A37<>"")
would freak them out, but this wouldn't
=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(ROWS($C$3:C3)<=COUNT(A$2:A$236)+COUNTIF(A$2:A$236,"*?"),INDEX(A$2:A$236,SMALL(IF(A$2:A$236<>"",ROW(A$2:A$236)-ROW(A$2)+1),ROWS($C$3:C3))),"")), 1, 1)
?

 

[mrjinx007]

LOL

You mean this
=FILTER(A2:A37,A2:A37<>"")
would freak them out, but this wouldn't
=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(ROWS($C$3:C3)<=COUNT(A$2:A$236)+COUNTIF(A$2:A$236,"*?"),INDEX(A$2:A$236,SMALL(IF(A$2:A$236<>"",ROW(A$2:A$236)-ROW(A$2)+1),ROWS($C$3:C3))),"")), 1, 1)
?

LOL. Absolutely.

 

[mrjinx007]

LOL

LOL. Absolutely.

They don't see that formula; just check boxes that items cells get filled.