0

I am trying to manage my sheet by using filter formula using 2 criteria is this possible or do I do I need to use another formula.

what I am using is

=Filter('Form Responses 1'!B2:U,'Form Responses 1'!B2:B="Original","Follow Up")

It does not work it does work if I omit the ,"Follow Up" but it does not give me all the data I need.

I want to show all the Originals and Follow ups on one sheet.

Thank you for any help

1 Answer 1

1

If I have "interpreted"* your request correctly, try this calculation:

=Filter('Form Responses 1'!B2:U,('Form Responses 1'!B2:B="Original")+('Form Responses 1'!B2:B="Follow Up"))

*that is, you want to get all the cells with the wording "Original" OR "Follow Up"

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.