I have a survey with a series of cascading questions that is giving me a bit of a fit when we download the results of a survey. It is a series of three questions relating to predation. Question one is a select_ one yes_no if there was predation present. If yes, then question two is a select_multiple about what type(s) of predators caused the predation which also includes an other as a selection. If you select other, a third 'question' text box appears so the user can type in the other predator not listed in the initial list. This third question's data is giving us a bit of a fit when we export the data into an Excel spreadsheet. My users will collect data in the field and many times they do not have an other thus the third question never appears to the crew in the field. At the end of a week, I download the data and copy and paste the new rows of data to a master Excel sheet stored in a secure cloud location. When I paste, it is as if this column does not exist and all the data shifts one column to the left and all the data does not appear under the correct heading. I have a two question cascading series of questions before this in the survey and it doesn't seem to have the same affect on the data. I have tried to put a default of NA for this question to at least get a placeholder but that doesn't seem to help or even show up unless other is selected. Any help would be appreciated!
