Forum Discussion
Checklist into paragraph
We are trying to turn parent checklist into narratives Example: My child uses words more than gestures to communicate (checked yes) My child uses 1-2 words to gain wants and needs (checked sometim...
Another option that is probably 'cleaner' is to use a series of formulas in that hidden column E of the format: =IF(D1="yes","Parent reported child uses words more than gestures","") which is also helpful because you can add in the alternative text: =IF(D1="yes","Parent reported child uses words more than gestures","Parent reported child uses gestures more than words.") Then at the bottom you can use =CONCAT(E:E)