I have a SharePoint library in which users are supposed to upload several reports every month after a certain date. The files uploaded have mandatory properties to determine the report name / month / year.
For each report there is a due date (e.g. the 5th of the month). The list of reports is saved in a SharePoint list and contains: report name, due date (number of days from the 1st of the month).
I would like to have a table dashboard that can tell me for the list of reports I am supposed to receive for a specific month, which one are on time, delayed, missing. Dashboard should look like this
Name | Due date | Jan-13 | ... | Dec-13
-------------------------------------------------
Report 1 | +5 | On time | ... | On time
Report 2 | +15 | Missing | ... | Not due yet
... | +2 | On time | ... | Delayed
Report N | +5 | Delayed | ... | On time
Is this feasible with SharePoint? Which way would you do so? I just need to be guided in the right direction as I don't know all capabilities around SharePoint.
Thanks!