This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help

Collaborator ID as formula

Topic Labels: Formulas
601 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!

Reply
1 Reply 1
Rupert_Hoffsch1
10 - Mercury
10 - Mercury
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