Query data from child list to include in parent list RRS feed

  • Question

  • I don't have a lot of experience with SharePoint.

    I have 2 related lists Consultants (parent) and Assignments (child). The Assignments lists contain start/end dates for a consultant assignments. In the Consultants list I want to create a calculated column indicating Availability. The calculation would be for a given Consultant if today is greater than the consultants maximum Assignment End Date then he would be "available". I created a view of the assignments list showing the max assignment end date for each consultant using the group by and totals properties. I cannot figure out how to link this data to my Consultants list in order to calculate Availability. Any suggestions? 

    Friday, October 13, 2017 5:13 PM