Assistance with Join collect with multiple criteria and evaluation action

Preston B
Preston B ✭✭
edited 09/20/23 in Formulas and Functions

I need to collect the email if the position is either Position 1, Position 2 or Position 3, and the status is “FTE” 

And If the status is “Open”, then collect from a helper row I built with a different email.

I got a single position to collect but am struggling with multiple choices and the evaluation if is “Open”.

=JOIN(COLLECT(Email:Email, [Position 1]:[Position 1], "Position 1", Status:Status, "FTE"))

Assistance is greatly appreciated, and tried using If and or statements but couldn't get it to work.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!