Scenario : I have 7 checkbox fields. For example say it is
Saturday. In Formula field I want to display all that are true as comma separated text in order from
Sunday - True
Friday - True
Formula Field should be -
I tried below formula for concatenating but comma's are coming extra if any one of the field is false.
IF( Sunday__c = true, 'Sunday', '') + ','+ IF( Monday__c= true , 'Monday', '')+ ','+ IF( Tuesday__c= true , 'Tuesday', '')+ ','+ IF( Wednesday__c= true , 'Wednesday', '')+ ','+ IF( Thursday__c= true , 'Thursday', '')+ ','+ IF( Friday__c= true , 'Friday', '')+ ','+ IF( Saturday__c= true , 'Saturday', '')
Note : I don't want to go for trigger