Worksheet functions for Ideas to be able to access linked records

We use a report to link ideas to the work items needed to meet that idea. On the dependency report I can show end dates on the related items, but would like to summarise this on the idea on the left hand side to see when the idea would be complete.