This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Why do you want to use IDs for this? You can search for the collaborator names and assign teams with an IF formula: IF(collaboratorColumn = “Name1”, “Team1”, Team2"). If you have more than two teams, you would use nested if formulas or the switch formula.