Google-sheets – Importing data found to be true from one Google sheet to another

data validationfilterformulasgoogle sheetsgoogle-sheets-query

I am trying to find a way to import data (text) from one sheet to another, via the same book. I assume it's going to need an IF or IFS formula because I only want data is that found to be "TRUE" (via the checkbox ability) to be imported into a list that has other text.

So basically, I want the data from Row A if Row B is true into a separate sheet.

Here's the link: https://docs.google.com/spreadsheets/d/1rnjmGPyzj7YsGaO1M5h97c8GoJPzQeIUHkv3JGKbrL8/edit?usp=sharing

Best Answer

Use FILTER or QUERY

Example using FILTER

=FILTER('Sheet 1'!A:A,'Sheet 1'!B:B)

Related Solutions

Google-sheets – why is one row skipped when including ranges from two sheets

The data is there, but it's out of sight because of the blank rows that are included due to the use of whole columns (A2:B). Filter the rows where A or B cells are not empty. One way to do that is by using QUERY(), i.e.:

=QUERY({{'source data 1'!A2:B};{'source data 2'!A2:B}},
"Select Col1,Col2 Where (Col1<>'' OR Col2<>'') Order by Col1",0)

Google Sheets – Consolidating Data from Multiple Columns

Short answer

On a copy of the sheet Desired example, try the following:

Clear B2:B
Add the following formula to B2

=ArrayFormula(TRANSPOSE(REGEXREPLACE(REGEXREPLACE(TRIM(
QUERY(TRANSPOSE(IF(C3:F12="Have",C2:F2,)),,2000000)
),": ",", "),":","")))

Explanation

IF is used to replace cell values Have by the column header (row 2), other values are replaced by blanks.
QUERY & transpose are used to concatenate the row values. This adds a space as separator.
TRIMS replaces the consecutive spaces by a single one.
The first REGEXREPLACE replaces : by , , the second to eliminate the remainding :
ARRAYFORMULA returns an array.