Pre/Post Survey matched by Employee ID

Christopher.Rose

I have a survey with field "Type" (Pre-Survey or Post-Survey). I have another field with a Unique id (employee ID). On the Pre-Survey we ask a question called "Segment" (which areas they work in), however we do not ask that question in the post-survey. I have the segment field allowing multiple selection then I use hidden fields to parse out the different segments for counting. The goal is that I need to have the segment information show up in both the pre AND post survey if the Employee ID matches. Any thoughts as to how I can do this? Happy to provide any additional clarifications when needed.

Paul Newcome

Are you able to provide some screenshots with sample data for context?

Christopher.Rose

Does that help?

Paul Newcome

The easiest way would be to use a helper column with something along the lines of

=IFERROR(INDEX(COLLECT(Segments:Segments, Segments:Segments, @cell <> "", [Global ID GID]:[Global ID GID], @cell = [Global ID GID]@row), 1), "")