Assigning unique ID/ number to pair || Cross Row Matching


Now that I can match the roommates - thank you Jeff! , I'd like to assign the pair a confirmation code that is the same for each of the roommates, but uniquely to the group.

For example Michael and Stepheni matched, so they would have the same code in the ConfirmCode column. It doesn't have to be a number just unique to the list and matched to the pair.

Thank you all for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!