Data Shuttle offload how to use the filter function

Joachim Mund

Hi all,

I have a smartsheet with column "Ebene" which contains values like 0, 1, 2, 3 ....

How can I filter to offload only values 0?

(Ebene=0) has no effect although (Ebene="0")

Any idea?

Thank you, Joachim

Genevieve P.

Hi @Joachim Mund

I was able to successfully offload Rows that had a value of 0 in a specific column (my column is called "Contacts") by using this filter:

Is this what your filter looks like?

If so, how is your Ebene column populated, is it from a formula or from a manual selection? I entered 0 manually into my test column.

Let me know if this works for you,

Genevieve

Genevieve P.

Hi @Joachim Mund

I was able to successfully offload Rows that had a value of 0 in a specific column (my column is called "Contacts") by using this filter:

Is this what your filter looks like?

If so, how is your Ebene column populated, is it from a formula or from a manual selection? I entered 0 manually into my test column.

Let me know if this works for you,

Genevieve

Joachim Mund

Thanks @Genevieve P. , you made my day😉

I thought that I have to write a filter function dmanually in the filter logic line and missed the "+" button which gives a well designed assistant for creating a filter.

Best wishes, Joachim

Genevieve P.

No problem at all! I'm glad I could help.

Ella

@Genevieve P. I am having some issues with multiple filters in Data Shuttle, which I just resolved, sorry to bother you.