My organization conducts a survey twice a year (January and July). We would like to be able to pipe in the respondents' prior answers to see if there have been changes. For example.
"In January, you answered your CEO made $123456 a year as of January 1, 2020. What does the CEO make as of July 1, 2020?"
"In January, you answered your CFO made $78901 a year as of January 1, 2020. What does the CFO make as of July 1, 2020?"
Where 123456 and 78901 are piped text or values from an Excel sheet (which itself was generated by the January answers).
Is there a way to do this?
Thanks!
Question
Piping in answers from prior survey responses
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.