Split source sheet into two separate sheets?


#1

And is it possible to split a source sheet into two separate sheets based on a condition that searches for a text in a column? Example, I have SKU’s with two separate suppliers and need to split the sheets but it needs to filter based on condition that SKU contains certain word or code

can i use the filter by option for both condition and query?


#2

@amaf
You can currently set this under the filter condition in the connection settings.
However for now this is not dynamic. I did suggest this so let’s see if this gets added to the roadmap.
If you need help with filters, just let us know.


#3

@eugenia thanks for adding it to the ideas list! :blush: