I want to bump this. Just came up for me. I am trying to emulate the output of a Pie Chart, which does this type of thing as part of its default function … I want to be able to get an array of all the ‘pie percents’.
P.S. Re copy-pasting. I think internally in Coda references in formulas are copy-pasted by their full $$ descriptors, not just the names. And it’s just the names when you paste it outside of Coda. My point is, correct CurrentValues may actually stay preserved when copying formulas within Coda.
My 2 cents on this topic, while having multiple CurrentValue's in this list and highlighting the matching scope with coloring/bold is a nice UX consistent with the current webapp, I believe that an explicit solution is required - certainly at the server API level.
So why not just focus on that first, and roll it out to the UI level as well as a first pass?
So something like :CurrentValue or some other “escaping” character (like ... for file systems) to refer to the outer scope(s), as mentioned earlier as a possible solution.
I don’t see how to get around the need for explicit syntax - the other solutions are just syntactic/visual sugar to layer on top of this.
Hey, @Ander, thanks for giving this a shot! Interesting with how you use Sequence and Nth, I did not know one could construct loops like that. Your approach is close to what I want, I want the sum of load per assignment, per user. As in: Stefan: 125%, Pontus: 50% etc. You’re close but I don’t get how to modify your column 8 to give that result.