Collaborator ID as formula

Topic Labels: Formulas
811 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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!

1 Reply 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?