I'm sorry if the title is completely butchering what I'm looking for, please let me know if should be updated.
Here's what I'm struggling with:
I have 11 checkboxes on an opp layout. I need the label/name of whatever ones are TRUE to be passed to a single text field.
Ex: Department 1 ✔️ Department 2 ✔️ Department 3 ✔️
FieldToContainTheDepartmentNames__c should = "Department 1, Department 2, Department 3"
The idea is to essentially "summarize" what departments are being sold into, into a single field vs. having to look at all the checkboxes for a ✔️. I could also then reference this field on a few other objects/places.
I've figured out how to have it check a single checkbox field, but not all 11 at once:
IF( ED__c = TRUE,"ED","")