Returning Non Duplicates when comparing two Multi-Select Columns
Is this possible in Smartsheet? I just can't seem to return what I need!
I've been playing with Join(Collect()) type statements but maybe I have overcomplicated it!
Scenario and requirements are explained in the screen shot.
Happy for you to say Column 1, Column 2 and Column 3 in any suggested formula, as my column headings here are just for explanation purposes.
Help Article Resources
Check out the Formula Handbook template!