Using OR with JOIN COLLECT

Options
Jesse Shockley
edited 09/12/22 in Formulas and Functions

I'm struggling with the syntax on this one.

I have this formula that in its current state Joins and Collects if both Sales Lead and Sales Lead 2 match [Metric Grouping].

=JOIN(COLLECT({Master_Event and Year}, {Sales Lead}, [Metric Grouping]@row, {Master Event Info Sales Lead 2}, [Metric Grouping]@row), " | ")


However, I need it to Join and collect if {Sales Lead} matches [Metric Grouping] OR {Sales Lead 2} matches [Metric Grouping]

Thanks in advance

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!