Mar 20 2023
- last edited on
Aug 03 2023
Hi. I'm trying to create a questionnaire on forms. This questionnaire has 21 questions, each has the same 4 answers:
0 Did not apply to me at all
1 Applied to me to some degree, or some of the time
2 Applied to me to a considerable degree, or a good part of time
3 Applied to me very much, or most of the time
From these 21 questions, some are related to anxiety, others to depression and others to stress.
When an individual replies to the questionnaire and I open excell with the results of the response, I want excell to show me the result of the questions according to those 3 categories, x amount of stress, x amount of anxiety and x amount of depression.
Now i am aware that one of the steps to do that is to add "value" to each answer, however my forms does not have that option.
My account is individual. Could that be the reason?
Otherwise, what are my options?
Mar 21 2023 06:42 AM
Mar 21 2023 09:30 AM
@JoondalupPsy if your Microsoft account has access to Power Automate then you could create a flow to save the form submissions to a SharePoint list. You could then either do the calculations there with a calculated column or do the calculations in the flow itself.
Microsoft Power Automate Community Super User