Match and Exclude

[danieldors]

Hello,

Im looking to add another condition to the formula below: [Extended Leave]='1', but have not been successful.

=if( Match([Work Type],'Generic-Full','ESS II',',[Work Type])

Thank you

[Chanty4u]

try this

if( Match([Work Type],'Generic-Full','ESS II') or  [Extended Leave]='1',[Work Type])

[danieldors]

Adding the or [Extended Leave]='1', worked in excluding those who are on extended leave but included all the other work types. I'm trying to exclude those on extended leave under the work types Generic Full and ESSII only.

[Chanty4u · Accepted solution]

im not sure but try below.

if( not Match([Work Type],'Generic-Full','ESS II') or  [Extended Leave]='1',[Work Type])

'or

if( not Match([Work Type],'Generic-Full','ESS II') and  [Extended Leave]='1',[Work Type])

[danieldors]

Without the Not it worked. Thank you.

if( Match([Work Type],'Generic-Full','ESS II') and  [Extended Leave]='1',[Work Type])

[Chanty4u]

cool 🙂   can you close this thread by making accept as solution.

best

chanty