I've been asked to create a project and task list within a SharePoint Online site. It seems simple but I want to ensure I have a workable and maintainable structure.
Base requirements:
- The site will contain multiple projects.
- Each project will have one or more tasks.
- Project status will be determined by a roll-up of the project-specific task list.
- An overview page will show all of the projects and roll-up statuses.
I thought this could be achieved by using a single Task list. A top level task for a Project then as sub-tasks as required. However, I can't see a way to have different fields for the top level task and the sub-tasks.
Any suggestions on how I can structure this?