In the rehearsals table, I am trying to find any characters that will appear in any of the scenes rehearsed that day, without duplicates. I have tried a rollup command and a function command. I have played with ARRAYFLATTEN and ARRAYUNIQUE to no avail. Can anyone help?
It would be great as well if I could then switch over to the Characters table and see what days any character might need to come to rehearsal. I think I must have linked something incorrectly at some point.