• Angie Harper 2
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
I have a custom field on the user object to populate a field (text) and I am at my character limit. When I use the same formula in a workflow I get this error: Error: Formula result is data type (Text), incompatible with expected data type (true or false). 

​IF(TEXT(UserType)='CSN Only','Chatter Only', 
IF(CONTAINS(Profile.Name,'Agent'),'Agent',
IF(CONTAINS(Profile.Name,'Country M'),'Country Manager',
IF(CONTAINS(Profile.Name,'System Admin'), 'System Admin',
IF(CONTAINS(Profile.Name,'Marketing'),'Marketing',
IF(CONTAINS(Profile.Name,'Product')||CONTAINS(Profile.Name, 'E-S'),'Product / Implementation',
IF(CONTAINS(Profile.Name,'Sales Support'),'Sales Support',
IF(CONTAINS(Profile.Name,'Recon'),'Reconciliation User',
IF(CONTAINS(Profile.Name,'Tech Support')||CONTAINS(Profile.Name, 'On Line Support'), 'Configuration/Online Support',
IF(CONTAINS(Profile.Name, 'Client Exec') || CONTAINS(Profile.Name, 'Client Manager')|| CONTAINS(Profile.Name, 'CRM Manager')|| CONTAINS(Profile.Name, 'Customer Relations')|| Profile.Name =  'EMEA DFX', 'CRM & Dealing',
IF(CONTAINS(Profile.Name, 'Accredit') || CONTAINS(Profile.Name, 'Credit')|| CONTAINS(Profile.Name, 'Refresh') || CONTAINS(Profile.Name, 'Enrolement'),'Accreditation/Credit/Enrollment',
IF(CONTAINS(Profile.Name, 'Customer Service') || CONTAINS(Profile.Name, 'Customer Support')||CONTAINS(Profile.Name, 'Mid Office'),'Client Support & Customer Service',
IF(Profile.Name ='GBP Global Banking Operations','Banking Implementation',
IF(CONTAINS(Profile.Name, 'FBA') || CONTAINS(Profile.Name, 'Sales Operations'),'Sales Operations & Finance',
IF(CONTAINS(Profile.Name, 'Investig') || CONTAINS(Profile.Name, 'Operations')|| CONTAINS(Profile.Name, 'Cash Letters')|| CONTAINS(Profile.Name, 'GBP NA Collections')|| Profile.Name =  'GBP NA ePay Support Rep'|| CONTAINS(Profile.Name, 'Ops')|| CONTAINS(Profile.Name, 'WU Retail Payments'), 'Operations & Investigations',
IF(CONTAINS(Profile.Name, 'Transworks') || CONTAINS(Profile.Name, 'External'),'Lead Generation External',
IF(CONTAINS(Profile.Name, 'Lead Gen'),'Lead Generation',
IF(CONTAINS(Profile.Name, 'L&D'), 'L&D',
IF(CONTAINS(Profile.Name, 'Sales Rep') || CONTAINS(Profile.Name, 'Sales Manager'),'Sales',
IF(CONTAINS(Profile.Name, 'EUR AR') || CONTAINS(Profile.Name, 'NA AR'),'AR&Collections',
IF(CONTAINS(Profile.Name, 'Compliance') ||  CONTAINS(Profile.Name, 'Derivatives'),'Compliance',
IF(Profile.Name ='GBP Global EDGE Migration User','Global SBA/VMS',
IF(CONTAINS(Profile.Name, 'API Enabled'),'EDGE HCL Support', 
IF(CONTAINS(Profile.Name, 'NA Audit') || CONTAINS(Profile.Name, 'Read Only')|| CONTAINS(Profile.Name, 'WUBS User'),'Read Only',
'Not Defined'
))))))))))))))))))))))))