I have run into one of those "I can’t believe Monday can’t do this" moments.
I run an online school and use Monday to track my Teachers and my Classes. A many-to-many relationship exists between the two: a teacher can teach multiple classes and a single class can have multiple teachers.
Since the data types are different, I store them in two different boards, one for Teachers and one for Classes, and use Connect Boards and Mirror Columns to show the relevant data wherever I need.
I want a report that shows me all of my Classes, by Teacher… and I can’t believe Monday can’t do this. Can someone please tell me that I’m wrong and a work-around exists?