How to filter a picklist

[PaulBappoo]

Hi, I created table 1 with a picklist to table 2, but I want to filter the picklist values to jut those where table2.field = a certain value

So I tried adding a filter formula into a rowlink formatted as a filter. I tried a few things, using =FILTER(... and without without the source field ID but couldnt find a way that works.

Any pointers would be greatly appreciated.

Thanks

[Quan-dec9]

I needed one value from my Types table to kick off an automation. Here is the filter I used:

=FILTER(Types,"Types[Type]=""YES""")

hth

[AndrewB]

@PaulBappoo the first argument in the filter formula is just a table. Remove the column reference.

So:

=filter(BusinessPartners, ...

[PaulBappoo]

Awesome, thanks both, worked a treat