

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If Match function with AND or OR?
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this:
If(Match([Status],'Active') and Match([Location],'Toronto'), 'Available/Toronto', FalseCondition)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this:
If(Match([Status],'Active') and Match([Location],'Toronto'), 'Available/Toronto', FalseCondition)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
