I'm trying to come up with a formula that will show the remaining picklist values that have not been selected by the user as the "remaining" choices. I'm using the formula listed below but unfortunately once I finalize the formula, I have over 5,000 characters. Everyone says I should utilize the CASE formula but I have not been able to make it work the way I need it. See below for an example of what formula I'm trying to create.
IF(ISPICKVAL(Program_Type__c , "Accessories - ACH"),
IF( !INCLUDES(Paperwork_Completed1__c , "App for Dealer Status"), "App for Dealer Status" &BR() , null) &
IF( !INCLUDES(Paperwork_Completed1__c , "Copy of Driver's License"), "Copy of Driver's License" &BR() , null) &
IF( !INCLUDES(Paperwork_Completed1__c , "Copy of Voided Check"), "Copy of Voided Check" &BR() , null) &
IF( !INCLUDES(Paperwork_Completed1__c , "ACH Authorization"), "ACH Authorization" &BR() , null) &
IF( !INCLUDES(Paperwork_Completed1__c , "Resale Certificate"), "Resale Certificate" &BR() , null) &
IF( !INCLUDES(Paperwork_Completed1__c , "Terms and Conditions"), "Terms and Conditions", null)&
IF( !INCLUDES(Paperwork_Completed1__c , "W-9"), "W-9", null),