Display form responses in other sheet

[Footnah]

Hi guys,

I have a google form that records responses to a sheet but I've added another column with tick boxes. I also have another sheet (that will be the public one) that has the same columns headings, just with no tick boxes.

What I want is for all of the entries (rows) transfer over to the other sheet once the tickbox is checked. I have this working with an If true statement. eg. =IF('Form Responses 1'!A2=TRUE,'Form Responses 1'!D2,""). This works (mostly. It actually seems really buggy for some reason) but my main question is how can I skip the blanks? If I have 3 rows populated, and the row 1 and 3 are ticked, but 2 isn't, the public sheet will show with row 1 and 3 populated but row 2 just blank. Is there a way I can compress them all?

I was thinking of something like counting rows for each true, but haven't been able to make that work yet so I'm asking for help.

I'm not sure how to provide an example for this?

Kind Regards,
Cameron.

[JeteMc]

I would imagine that you could use an array formula INDEX/SMALL/IF to accomplish what you want using google sheets.
Based on the formula in post #1 I would guess

Please Login or Register  to view this content.

If there are more than 19 responses on Form Responses sheet then the 20's in the formula will need to be changed to match the number of the last row with tick boxes.
Let us know if you have any questions.