Filter multiple selection values from a column to another one

1

Hi!

I have a CODA doc that I’m using to track all of the integration projects I have currently going on. Part of the tracking is that I keep track of the features released for that project. I have a table “catalogue” from were I pull all the available features for me to select, and then I want another column that shows which Features are pending to be implemented by filtering from the catalogue the selected fields from the user.

I tried filtering the “Not Supported Features Yet” column based on the catalogue import minus the selected features from the user, but with no luck :
Features.Filter(thisRow.Features)

Anyone who can help on this matter? Here’s a quick doc I created to illustrate the issue:

Thanks!

2

Hi! Can you allow view/edit access to your sample DOC?

3

Hi @Keith_Galloway thanks for the heads up! I have changed the permission of the doc, can you please check now?

Thanks in advance for the help!

4

Hi @Rolando_Castanon,
Try this formula and see if it works for you.
Features.Filter(not(thisRow.Features.Features.Contains(Features)))

1 Like
5

Or,
Features.Filter(not(thisRow.Features.Contains(CurrentValue)))

4 Likes
6

@mallika
I used this one!
Features.Filter(not(thisRow.Features.Contains(CurrentValue)))

It worked perfectly!
Not sure if it was too easy but I was stuck with that for the last week, thanks for the help. I think my issue was that I was comparing table to values and it should have been values to values.

Thanks!

2 Likes