Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Collaborator ID as formula

Topic Labels: Formulas
274 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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?