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...
You can join text using functions like CONCATENATE or CONCAT or just use the join operator '&'
You may need to have another cell (maybe hidden) with the actual text you want to append if checked.
Then you can =IF(D1="yes", E1,"") & IF(D2="yes", E2,"") &IF(D3="yes", E3,"") & ...
Where column D is where they mark it "yes" and column E (hidden?) is the actual text to append.
PS (sorry for the correction but the prior was a response to another thread)