Forum Discussion
Copy over only certain columns to new worksheet if cell contains specific text
How do I copy over only the columns "APN" and "Completed Date" to a new worksheet if Status is COMPLETED (Status is a dropdown list that has several status options).
=FILTER('Sheet Name!A:A, 'Sheet Name'!D:D="COMPLETED")
and
=FILTER('Sheet Name!C:C, 'Sheet Name'!D:D="COMPLETED")
where Sheet Name is the name of the sheet with the data.