filter table based on matching fields

[bcoronado]

Hi, 

I've created a table filter based where the provider ID and need ID should match. How can I write this to include a secondary piece where the provid ID and need ID match but including the need status to equal 'identified'.

=if(match([Need Provider Id],'13651'),[Need Id] )

Thank you, Brittany

[edwin]

can you pls share your expressions or sample data?  the expression in your post is just an example rt?  as it is hard coded.

[QFabian]

Hi @bcoronado , if you are talking about an expression :

=sum( if( [provider ID] =  [need ID] and [need status]  = 'identified', FieldX)

And if it is script, and each field is present in the same table :

Load

fields....,

if( [provider ID] =  [need ID] and [need status]  = 'identified', 'Same ID /Identified', 'Same ID /Identified')  as NewFilter

From your source ;

[bcoronado]

Here is an example of the data.

[bcoronado]

It's been solved! Thank you for your help.

=if(match([Need Provider Id],'13651') AND match (
[Need Name],'Benefits Screening') AND match (
[Need Status],'Pending Contact'),[Need Id] )