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

  • 1
    can you provide an example of your desired output?
    – user0
    May 25, 2019 at 13:30
  • I want answers found to be true on the first sheet to be added to the list on the "mastered" sheet. So nothing gets transferred over unless the checkmark is clicked (the equivalent of true). There is an array formula to the side of the chart on the first sheet that is kind of doing what I want, but its all in one cell, separated by commas and I want each individual true finding the be in its own cell.
    – Soli
    May 25, 2019 at 16:32

2 Answers 2



Example using FILTER

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

=FILTER('Copy of Dolch Sight Words'!A:A, 'Copy of Dolch Sight Words'!B:B = TRUE)


=FILTER({'Copy of Dolch Sight Words'!A:A,'Copy of Dolch Sight Words'!C:L}, 
'Copy of Dolch Sight Words'!B:B = TRUE)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.