Hi @NYCEDU_Admin - you could do this with an IF()
statement or a SWITCH()
statement, e.g.:
IF(
{Ethnicity} = 'Taiwanese',
'Yes',
IF(
{Ethnicity} = 'Chinese',
'Yes',
IF(...)
)
)
but I think this is going to get pretty complicated pretty quickly.
As Ethnicity is a linked field, a better way is to add the racial grouping to the Ethnicity table and then lookup this value back into the contacts table:
As you can see on Person 4, if you select two ethnicities, you will get two occurrences of the ethnic grouping.
If you then want a column that has a Y/N on, for example, “Asian” you could then add a formula field which works this out:
using:
IF(FIND('Asian', {Ethnic Grouping}), 'Y', 'N')
JB
Hi @NYCEDU_Admin - you could do this with an IF()
statement or a SWITCH()
statement, e.g.:
IF(
{Ethnicity} = 'Taiwanese',
'Yes',
IF(
{Ethnicity} = 'Chinese',
'Yes',
IF(...)
)
)
but I think this is going to get pretty complicated pretty quickly.
As Ethnicity is a linked field, a better way is to add the racial grouping to the Ethnicity table and then lookup this value back into the contacts table:


As you can see on Person 4, if you select two ethnicities, you will get two occurrences of the ethnic grouping.
If you then want a column that has a Y/N on, for example, “Asian” you could then add a formula field which works this out:

using:
IF(FIND('Asian', {Ethnic Grouping}), 'Y', 'N')
JB
This was exactly what I needed, thank you!!!