Collaborator ID as formula

Hi Airtable community!

I’m looking for a formula which fetches collaborator IDs

The reason is, I want to assign through another formulas a set of teams.

So, if user 1 is true in the ID column, return text value “team 1”

If that makes s3ense!

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.

Does that help?

2 Likes

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.