Return to Answer

added 111 characters in body

Source Link

edited Mar 3, 2022 at 17:59

If I have "interpreted""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"

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"))

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"

Source Link

created Mar 3, 2022 at 17:52

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"))