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!
Page 1 / 1
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?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.