Text Formula String Concatenation - Omit Trailing Comma

@AdrianLarson I used your suggestion for a similar solution and it worked for a year or so, until I was asked to include more Checkboxes (12 in all) in the formula, then I got:

Error: Compiled formula is too big to execute (5,713 characters). Maximum size is 5,000 characters.

I found a simpler solution. Include the ", " in each result, then add a period to the end of your IF statements. Wrap the code with SUBSTITUTE to replace ", ." with null in order to remove the trailing comma at the end of your text

SUBSTITUTE(
IF( Sunday__c, 'Sunday, ','') &
IF( Monday__c, 'Monday, ','') &
IF( Tuesday__c, 'Tuesday, ','') &
IF( Wednesday__c, 'Wednesday, ','') &
IF( Thursday__c, 'Thursday, ','') &
IF( Friday__c, 'Friday, ','') &
IF( Saturday__c, 'Saturday, ','') &
'.'),
', .', NULL)

I think this is how far you have to go to implement formula here. I'm doubtful its compile size will be under the limit, but I haven't checked.

IF(Sunday__c, 'Sunday' & IF(
    OR(Monday__c, Tuesday__c, Wednesday__c, Thursday__c, Friday__c, Saturday__c), ',', ''
), '') &
IF(Monday__c, 'Monday' & IF(
    OR(Tuesday__c, Wednesday__c, Thursday__c, Friday__c, Saturday__c), ',', ''
), '') &
IF(Tuesday__c, 'Tuesday' & IF(
    OR(Wednesday__c, Thursday__c, Friday__c, Saturday__c), ',', ''
), '') &
IF(Wednesday__c, 'Wednesday' & IF(
    OR(Thursday__c, Friday__c, Saturday__c), ',', ''
), '') &
IF(Thursday__c, 'Thursday' & IF(
    OR(Friday__c, Saturday__c), ',', ''
), '') &
IF(Friday__c, 'Friday' & IF(Saturday__c, ',', ''), '') &
IF(Saturday__c, 'Saturday', '')

A couple notes:

  • You don't need to check Checkbox__c = true for a checkbox in a formula. Just use Checkbox__c.
  • The proper string concatenation operator is a single ampersand (&).