Creating Vertical Lists with Checkboxes

 =TEXTJOIN(CHAR(10), TRUE, FILTER(B4:B5, C4:C5=TRUE))

Today, I realized you can use a formula to make a list inside a cell in Google Sheets. 

Why would you want to do this?

In my case,  I am trying to make the IEP/ILP process smoother. It doesn't make sense to keep rewriting information each time you write a report about a student. I think using a Google Sheet to make a document will be easier. 

I was able to put text together using TEXTJOIN and separated by a space or by comma before, but ChatGPT showed me that I could add the CHAR(10) -- line break -- to a formula to make the list.

This formula puts checkmarks in a list, in order of day, combined with the labels from the matrix.

Save this formula for later. 

=TEXTJOIN(CHAR(10), TRUE, ARRAYFORMULA(IF(B81:F86, A81:A86 & " " & B80:F80,)))

I ended up separating them out into the columns to the right of the checkboxes.