Populating a cell based on the marked up check box
I'm looking for a formula that produces the text that wasn't checked, "Joey also went to the store" to be displayed on the highlighted cell. How would that pan out?
In other words, I would like every cell in column 2 that has text in it and is NOT flagged all in one cell.
I tried using a formulate like =IF(NOT(ISBLANK([Column 2:Column 2])),JOIN(COLLECT(Column 2]:[Column 2], [Column 3]:[Column 3], @cell = 0), "-")
But this hasn't given me any luck. Any suggestion would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!