I am trying to use the filer formula to get data from a Google form response in Google Sheets
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 Original and Follow ups on one sheet.
Thank you for any help
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 Original and Follow ups on one sheet.
Thank you for any help