I've been tasked to move information currently being tracked in Excel into SharePoint. Attached is screenshot of excel file they use to collect information. Now I need to move it into SharePoint Online.
Question are predefined. Responses should be able to be extracted into excel or somewhere they can see the question and its related answers/corrective actions/date/comments etc. Those question should come up in a report when they generate one.
I created a SP list with the following columns:
Questions - drop down
Yes/No/NA - Radio
Corrective - Text
Date - Date
Reporting for this will not be reader friendly as, apart from question, none will have an identifier or unique value.