Does anyone know how to filter specific items into a single, bulleted list? I my “master” table, in one column I have a teacher’s name, and in another I have a corresponding student. I wanted to have a separate view of the main table where the teacher’s name is in one column, and ALL the students are in a second column formatted as a bulleted list. The formula I frankensteined together was this one:
[Master Student Information Table].Filter([Teacher Column].ToText()=thisRow.[Teacher Column].ToText()).[Student Name].First().BulletedList()
It sort of works, but only shows the first entry as a bulleted list. Any ideas what I’m doing wrong? Honestly, I’m crap at formulas (just can’t wrap my head around them) so it’s probably something simple I’m doing/not doing.