When using collections in reporting, the data in the collections cannot be sorted. If pulling data such as upcoming time off, the dates cannot be sorted in chronological order. This can be very confusing. See screenshot attached.
We have a similar need!! We show projects by earliest live date, but then also need the collection of task lists sorted in chronological order. There HAS to be a way to do this! Please upvote this idea!