Adding an AND into a formula

cghallo_UCDenver

Good morning, Community!

Current formula (which is working): =IF(CONTAINS("APP", [Employment Type]@row), JOIN([Dropdown Selection]@row:[Employee Status]@row, "; "))

However, I need to include if the Employee Status equals Active within the above and not sure on the syntax?

Genevieve P.

Hi @cghallo_UCDenver

Try this:

=IF(AND(CONTAINS("APP", [Employment Type]@row), [Employee Status]@row = "Active"), JOIN([Dropdown Selection]@row:[Employee Status]@row, "; "))

Cheers,

Genevieve

Paul Newcome

@cghallo_UCDenver The last two examples in that link show how to use an AND function that has another function within it. Basically the CONTAINS function is one of the "logical_expressions".

Paul Newcome

Here's some info on the AND function:

https://help.smartsheet.com/function/and

cghallo_UCDenver

That doesn't show where specifically to add the in within my current formula that has contains which is what I'm not sure on.

Genevieve P.

Hi @cghallo_UCDenver

Try this:

=IF(AND(CONTAINS("APP", [Employment Type]@row), [Employee Status]@row = "Active"), JOIN([Dropdown Selection]@row:[Employee Status]@row, "; "))

Cheers,

Genevieve

Paul Newcome

@cghallo_UCDenver The last two examples in that link show how to use an AND function that has another function within it. Basically the CONTAINS function is one of the "logical_expressions".