Jul 07 2021 06:12 AM
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 sometimes)
Narrative to say:
Parent reported that X uses more words to communicate and sometimes uses 1-2 words to gain wants and needs.
Can someone lead us into the direction of how to search this?
Jul 07 2021 11:59 AM - edited Jul 07 2021 12:07 PM
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)
Jul 07 2021 12:12 PM