Forum Discussion
Is there a formula that can populate a cell with a column header text if a checkbox is ticked?
I have a fairly simple spreadsheet where a list of names will have made a meal choice from a list which is shown by a ticked checkbox in the corresponding column. What I would like is to have a list...
Assuming that you have Microsoft 365:
The formula in B2 is
=TEXTJOIN(", ", TRUE, FILTER($C$1:$H$1, C2:H2=TRUE, ""))
- Thank you so much, worked a treat 🙂
