Multiple Check Boxes - Pre-Fix, joining values based on multiple check boxes.
What would be the best formula to join "text" from multiple check boxes if values are true or false?
I would like to populate, the in the grey column, the values of each check box if any are true with a "text value" of the name of the check box column.
I have several grey columns that will be used in with join/collect on another sheet.
I've tried this, but seems to be incorrect:
=JOIN(IF(Response@row = 1, "Response", IF(Reoccurring@row = 1, "Reoccurring", IF(Technician@row = 1, "Technician", IF(Set-Up@row = 1, "Set-Up", IF(Equipment@row = 1, "Equipment", ""))))),", ")
Help Article Resources
Check out the Formula Handbook template!