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!
Collaborator ID as formula
+1
+21Why 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?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.