If Match function with AND or OR?

[drminaker]

Hi,

Can someone please tell me if it's possible to use AND or OR with a the Match function?

I'm trying to create a custom dimension where I want to pull records from staff who are [Active] and in [Toronto] and name this as 'Available/Toronto'.

The match statements work fine on their own, but I need to combine them using AND. I've tried using several different ways to do this and can't get it to work. Any help, much appreciated.

if(match([Status],'Active'), 'Available/Toronto'

if(match([Location],'Toronto), 'Available/Toronto'

Thanks!

R.

[sunny_talwar · Accepted solution]

May be like this:

If(Match([Status],'Active') and Match([Location],'Toronto'), 'Available/Toronto', FalseCondition)

[drminaker]

Perfect, thank you so much!

I must have had a comma or parentheses in the wrong place or something. I searched all over trying to find an example of something this basic and wasn't able to. I'll be sure to bookmark this for another time!

R.