@Raul_San_N.H @Al_Chen Great question, and definitely acknowledge this isn’t as straightforward as we’d like it to be!
The main issue here is that we can’t currently “dereference” an array like you can an single reference in the canvas. An example is entering the formula
=@Sprint.[Sprint Start] in the canvas. Given
Sprint returns an explicit reference to a row in the Sprints Table, we can dereference that and project values like the Start, End, Owner, etc.
The result of Raul’s formula actually returns an array of references/Sprints (even though that array has one value in this particular case). So trying to do the projection does not resolve. Entering
.First() then resolves to a single reference, which we can then project from.
The choice here is either 1. make it clear that Raul’s formula returned an array, not a single reference, or 2. allow for dereferencing an array. Have floated this to our cofounder - will let you know once we have a resolution!