How can you filter entire columns depending on the value?

Ask a question
1

Hi there,
I’m pulling data from my Squarespace e-commerce to get a Google Sheet for my shipping agency.

The products I sell are both digital and physical, and a customer can buy both on the same order. How could I filter the columns that contain the digital products so my shipping agency only gets the relevant content for them?

Thanks!

2

Hi @Alejandro_Masferrer! Yes, you can definitely do this. Is there anything in the dataset that says whether or not the order is digital or physical? If so, you can use the Row Filter set to remove rows that meet a certain criteria. Does that make sense?