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
Oct 19, 2021 04:47 AM
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!
Oct 19, 2021 07:54 AM
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?