Sharepoint project management master project list

%3CLINGO-SUB%20id%3D%22lingo-sub-2001134%22%20slang%3D%22en-US%22%3ESharepoint%20project%20management%20master%20project%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2001134%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20an%20end-user%20on%20O365%20government%20cloud.%26nbsp%3B%20What%20I%20would%20like%20to%20do%20is%20use%20sharepoint%20as%20a%20project%20management%20tool%20where%20all%20of%20my%20subsites%20are%20projects%20and%20I%20have%20a%20roll-up%20of%20all%20of%20those%20subsites%20(projects)%20on%20the%20main%20page.%26nbsp%3B%20I%20figured%20out%20how%20to%20roll-up%20the%20subsite%20list%20(%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-the-highlighted-content-web-part-e34199b0-ff1a-47fb-8f4d-dbcaed329efd%3Fns%3Dspostandard%26amp%3Bversion%3D16%26amp%3Bsyslcid%3D1033%26amp%3Builcid%3D1033%26amp%3Bappver%3Dspo160%26amp%3Bhelpid%3Dwssenduser_commsitenewsemptystatetile_highlightedcontent_fl855981%26amp%3Bui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%23bkmk_filtersort%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eusing%20this%3C%2FA%3E)%20but%20what%20I%20can't%20figure%20out%20how%20to%20do%20is%20include%20some%20metadata%20on%20those%20sites%20(aka%20custom%20fields%2Fcolumns)%20so%20that%20I%20can%20filter%20that%20information%20in%20different%20ways.%26nbsp%3B%20For%20example%2C%20what%20I%20would%20love%20the%20rolled-up%20list%20of%20subsites%20to%20look%20like%20is%20the%20below.%26nbsp%3B%20Thoughts%3F%26nbsp%3B%20Thanks%2C%20Greg.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%3EProject%20name%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3EStatus%20(in%20progress%2C%20completed%2C%20etc.)%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3EPlanning%20Year%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3ECompleted%20Year%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3EAssigned%20to%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2001134%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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 nameStatus (in progress, completed, etc.)Planning YearCompleted YearAssigned to
     
0 Replies