I am an end-user on O365 government cloud. What I would like to do is use sharepoint as a project management tool where all of my subsites are projects and I have a roll-up of all of those subsites (projects) on the main page. I figured out how to roll-up the subsite list (using this) but what I can't figure out how to do is include some metadata on those sites (aka custom fields/columns) so that I can filter that information in different ways. For example, what I would love the rolled-up list of subsites to look like is the below. Thoughts? Thanks, Greg.
| Project name | Status (in progress, completed, etc.) | Planning Year | Completed Year | Assigned to |
| | | | | |
