Checklist into paragraph

%3CLINGO-SUB%20id%3D%22lingo-sub-2523139%22%20slang%3D%22en-US%22%3EChecklist%20into%20paragraph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2523139%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20trying%20to%20turn%20parent%20checklist%20into%20narratives%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3EMy%20child%20uses%20words%20more%20than%20gestures%20to%20communicate%20(checked%20yes)%3C%2FP%3E%3CP%3EMy%20child%20uses%201-2%20words%20to%20gain%20wants%20and%20needs%20(checked%20sometimes)%3C%2FP%3E%3CP%3ENarrative%20to%20say%3A%3C%2FP%3E%3CP%3EParent%20reported%20that%20X%20uses%20more%20words%20to%20communicate%20and%20sometimes%20uses%201-2%20words%20to%20gain%20wants%20and%20needs.%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20lead%20us%20into%20the%20direction%20of%20how%20to%20search%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2523139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2524534%22%20slang%3D%22en-US%22%3ERe%3A%20Checklist%20into%20paragraph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2524534%22%20slang%3D%22en-US%22%3EHow%20about%20making%20that%20Total%20Cash%20column%20be%20a%20Net%20Cash%3A%3CBR%20%2F%3E%3DF5-G5-I5%2BH4%3CBR%20%2F%3ESo%20before%20you%20make%20the%20deposit%20it%20will%20show%20how%20much%20cash%20you%20have.%3CBR%20%2F%3EAfter%20you%20make%20the%20deposit%20(assuming%20cash%20is%20%2B%20and%20you%20deposit%20it%20all)%20it%20will%20show%200.%3CBR%20%2F%3EIf%20the%20prior%20day%20Cash%20is%20still%20negative%20then%20that%20is%20accounted%20for%20in%20that%20day's%20cash.%3CBR%20%2F%3EIf%20you%20don't%20make%20a%20deposit%20then%20next%20day%20also%20adds%20that%20cash%20in.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

2 Replies

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)

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)