Adding an AND into a formula

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?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!