I need to make a questionary where you will have as a result 2 roles maximum per person, that would be calculated after add all the scores from 6 questions. For instance:
Which behavior I dislike more:
1- Discussion between workmates : (number from 0 to 10)
2- People not involved in the project: (number from 0 to 10)
etc…
Then this points have to be added with other question related and I will have a rank of different roles.
There is some calculations that i have in excel but it is not easy for me find the solution here.
Any help please!!! ???
Best answer by john.desborough
@Liz - still sitting on the beach here.. but getting the top score is easy to do inside the typeform logic - it is a convoluted series of logic rules but it will work .. getting the top 2 to present is better done by using Google Sheets to do the calculations and then to email the user the pdf report of the results.
that also allows you more control over your user experience with the report
i’ve been working on the logic example from time to time to address this issue but not touching it until at least after Labour Day when i am back in the office
Hi @gabrielmedig Thanks for stopping by the community! It isn’t possible to import Excel formulas, but do you mind sharing a bit more about the specific formula you would like to add? We can try to think of a workaround!
First, the formula is about make a ranking with the sum of the points that each answer has from the people, for example:
A- Which behavior I dislike more:
1- Discussion between workmates : (number from 0 to 10) = 7(example)
2- People not involved in the project: (number from 0 to 10) = 2
….
B- What is more important for you at the start of a project:
1- Time to create ideas : (number from 0 to 10) = 5
2- Start as soon as possible to make the project: (number from 0 to 10) = 4
…..
So now, each question 1- is a role, and this role(in this example) would have 7 + 5 = 12 points.
After this calculation for all the questions, I would have 8 roles(so there are 8 questions per topic, in this case I wrote 2), and then I need to make a ranking of them as a result:
role 1 = 7 + 5 = 12
role 2 = 2 + 4 = 6
….
Finally, show to the client the top 2 with more points which would be his potencial roles in a organization.
@Liz - still sitting on the beach here.. but getting the top score is easy to do inside the typeform logic - it is a convoluted series of logic rules but it will work .. getting the top 2 to present is better done by using Google Sheets to do the calculations and then to email the user the pdf report of the results.
that also allows you more control over your user experience with the report
i’ve been working on the logic example from time to time to address this issue but not touching it until at least after Labour Day when i am back in the office
