I work at a training center. Our customers sign up for classes. We track customers through a board called “Deals”. Each deal may consist of more than one student. I track the students as subitems on the Deal board. I then have a summary column on the Deal board that sums up the number of subitems (i.e. students) for each deal, to identify the number of students for each deal.
We also have a Classes board. Each deal is assigned to a class. A class can have multiple deals associated with it. To show the total number of students in each class, I use a mirrored column to get the count of the total number of students across the multiple deals mapped to the class.
So far, so good. All that works. The problem is a simple one. I need the number of riders in the class to appear in the class’ title. When I create an automation to do that, though, it shows each individual student as “1” instead of showing the actual entry it calculated for the number of students in a Deal. For example, if Deal 1 has 3 students and Deal 2 has 1 student, my summary column on my Class board will in fact show “4”, but when I try to use that “4” in an automation to create the class title, it displays “1,1,1,1”.
I’m hoping for some sort of equivalent to Excel’s “Paste Values” that would let me take the calculated value and turn it into text that I can use in the title. Or, of course, some other work around. Hope all that makes sense, and thanks for any help!