This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
automadien
6 - Interface Innovator
6 - Interface Innovator
See Solution in Thread

‎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!

0 Kudos
Reply
1 Reply 1
Rupert_Hoffsch1
9 - Sun
9 - Sun
See Solution in Thread

‎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?

Reply
Copyright © 2023 Khoros, LLC