Hi there
I’m currently running an exercise where we are asking a group of 30 users 10 sets of questions each. Each set of questions has its own web form so there should be 10 responses from each user (300 separate rows in total). I have this working fine.
The users have requested a ‘dashboard’ which would allow them to see how many questions they have left to answer. I can show each answer as ‘Red’ or ‘Green’ depending on if they have answered the question. I have this working fine.
I can create a report for the but the report shows each submission on a separate ROW. Ideally I want just one row per user with the 10 questions along the row (the submissions ‘ROLLED UP’ and grouped by user). Is this possible?
I have also been trying to see if there is a way to have a formula in one sheet reference data in another sheet as this would allow me to achieve what I am trying to do via the reports, but I can’t see anywhere that shows how to set formula up across sheets. Is this possible?
Any help or guidance greatly appreciated.