title: Survey completness problems in Google Sheets
body: <p>I'm trying to have information about the completness in some survey results exported in to a Excel Format I'm using Google Sheets, as every survey there is questions and subquestions the subquestions have a conditional, Example: 4. How are you today? multiple choise answers: Good, Bad, Prefer not to say, so there we have 3 answer options if we click good there is a conditional and the subquestion will be: Why?. So in my survey there is 8 questions and question 4, 7 and 8 has conditional questions if someone answer &quot;Yes&quot;. Now here is my problem to calculate the percentage of completness I used this relation: <code>number of inputs in the survey/number of expected answers</code>, But as I mentioned before the conditional affects this <strong>expected answers</strong> this Variable is dynamic depending on the answers from question 4, 7 and 8. So I would like to obtain this Variable for every case, if someone put information will have an ID if we have 20 persons doing the survey we will have 20 ID's. So for every record of answers the number will change depending on the inputs from Question 4, 7 and 8. I have prepared a document in Google sheets will the full aproach that I tried but is still hard to have it right I would like to have some help with this.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1Uov1TIhy3jfqPdJ2gZXVjLENSDELacwtWt0S4ToRbrw/edit?usp=sharing" rel="nofollow noreferrer">Link to the spreesheet</a></p>
  <p>Here is an image about it:</p>
  <p><a href="https://i.stack.imgur.com/uGcjC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uGcjC.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/PQrgN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PQrgN.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/CqxSv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CqxSv.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/mGRUu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mGRUu.png" alt="enter image description here" /></a></p>