I have table where I’m tracking attendance versus enrollment of a training workshop. I’m using a name field that also has a lookup field displaying whether someone goes by a formal name or an alias. I have another field that has an array of all attendees of the workshop an individual has enrolled in. I’ve had some success finding the enrollee’s name in the array of attendance to determine whether the enrollee is among those in the array. However, I’m running into an issue where, in some cases the enrollee, though listed as using an alias, may in fact have attended the workshop under their formal name. So, I need to use a formula that can search for and find either the alias or the formal name in the array, but it doesn’t seem to be working.
Here’s what I have in the case of an enrollee who uses an alias who also attends the workshop using that alias:
FIND(
(IF({Alias (from Name)},{Alias (from Name)},Name)),
{Workshop Session 000 Attendance})
I have tried including AND, but nothing is found:
IF({Alias (from Name)},
FIND(
AND({Alias (from Name)},Name),{Workshop Session 000 Attendance}),
FIND(Name,{Workshop Session 000 Attendance}))
I have also tried including OR, and nothing is found:
IF({Alias (from Name)},
FIND(
OR({Alias (from Name)},Name),{Workshop Session 000 Attendance}),
FIND(Name,{Workshop Session 000 Attendance}))
I can’t see what I’m missing. Any help would be appreciated.