I want to copy the text in Cells A1 and B1 into another spreadsheet that will be emailed out, but only if the text in Cell E1 has a "YES" in it.

How would I go about doing something like this in Google Sheets?

  • Hey @Amel, you can try the functions switch + importrange.
    – pjmg
    Dec 13 '19 at 8:53
  • 1
    Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Jan 12 '20 at 15:33

Is there a way to copy text from two cells into another spreadsheet only if another cell has a YES?

Yes, assuming A1 and A2 are in Sheet1 and your YES is in Sheet2 the following code will import the information into Sheet2:

  • This worked wonderfully! Thank you! Dec 13 '19 at 12:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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