I have a formula that sync multi-select picklist field from accounts to contacts object but having issue on character limit.
Eg.,
IF( INCLUDES(Account.Category2__c ,"Accessories (Bags, hats, scarves etc)"),
"Accessories (Bags, hats, scarves etc)","")
&
IF( INCLUDES(Account.Category2__c ,"Accountants & Bookkeepers"),
"Accountants & Bookkeepers","")
&
IF( INCLUDES(Account.Category2__c ,"Activities"), "Activities","")
We have a long list of this category2. If i include all the listed category on the formula. It only allows upto the character limit. Is there other way on how to sync multi-select picklist field from accounts to contacts object?
Accessories (Bags, hats, scarves etc) Accountants & Bookkeepers Activities Activities & enrichment Adult Enrichment Adventure Holidays Aesthetics Afternoon Tea Airconditioning etc.....................................................