Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
try this
if( Match([Work Type],'Generic-Full','ESS II') or [Extended Leave]='1',[Work Type])
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.
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])
Without the Not it worked. Thank you.
if( Match([Work Type],'Generic-Full','ESS II') and [Extended Leave]='1',[Work Type])
cool 🙂 can you close this thread by making accept as solution.
best
chanty