function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Kathleen Munetz-Vasquez 3Kathleen Munetz-Vasquez 3 

Case formula for picklist values

I need help. I have created a formula field - using case, it's working for every subject except for the subject "About Enterprise Florida"; if this subject is choosen the formula field I created returns a blank. See below. I originally was trying to use includes but kept running into syntax errors.

CASE( Subject__c , "Career Opportunities with Enterprise Florida", "Administration - Human Resources", 
CASE( Subject__c , "Vendor Inquiry", "Administration - Human Resources", 
CASE( Subject__c , "Sports", "Administration - Salesforce", 
CASE( Subject__c , "Data & Statistics", "Business Development", 
CASE( Subject__c , "Expand an Established Florida Business", "Business Development", 
CASE( Subject__c , "Florida Industry Information", "Business Development", 
CASE( Subject__c , "Foreign Direct Investment (FDI)", "Business Development", 
CASE( Subject__c , "Incentives", "Business Development", 
CASE( Subject__c , "Locate a Business to Florida", "Business Development", 
CASE( Subject__c , "Minority and Small Business Financing", "Business Development", 
CASE( Subject__c , "Rural Florida", "Business Development", 
CASE( Subject__c , "Small Business Assistance", "Business Development", 
CASE( Subject__c , "About Enterprise Florida - EFI Investor Relations", "External Affairs", 
CASE( Subject__c , "About Enterprise Florida - EFI Partner / Stakeholder", "External Affairs", 
CASE( Subject__c , "About Enterprise Florida - General Questions", "External Affairs", 
CASE( Subject__c , "Stakeholder Council Membership", "External Affairs", 
CASE( Subject__c , "Africa Trade Expansion Program", "International Trade & Development", 
CASE( Subject__c , "Export and Trade Assistance", "International Trade & Development", 
CASE( Subject__c , "Trade Show Information", "International Trade & Development", 
CASE( Subject__c , "About Enterprise Florida - EFI Leadership", "Marketing & Communications", 
CASE( Subject__c , "About Enterprise Florida - Press Inquiry", "Marketing & Communications", 
CASE( Subject__c , "About Enterprise Florida - Public Records Request", "Marketing & Communications", 
CASE( Subject__c , "Buildings & Sites / GIS", "Marketing & Communications", 
CASE( Subject__c , "Marketing Inquiry", "Marketing & Communications", 
CASE( Subject__c , "Sponsorship Opportunity", "Marketing & Communications", 
CASE( Subject__c , "Subscriptions & Newsletters", "Marketing & Communications", 
CASE( Subject__c , "Website/Tech Support", "Marketing & Communications", 
CASE( Subject__c , "Florida Defense Alliance & FDSTF", "Military & Defense", 
CASE( Subject__c , "International Offices - Enterprise Florida", "International Offices", 
NULL)))))))))))))))))))))))))))))


 
Best Answer chosen by Kathleen Munetz-Vasquez 3
Jolly_BirdiJolly_Birdi
Hello @Kathleen

Please try this below Code:
  
CASE( Subject__c , 'Career Opportunities with Enterprise Florida', 'Administration - Human Resources', 
'Vendor Inquiry', 'Administration - Human Resources', 
'Sports', 'Administration - Salesforce', 
'Data & Statistics', 'Business Development', 
'Expand an Established Florida Business', 'Business Development', 
'Florida Industry Information', 'Business Development', 
'Foreign Direct Investment (FDI)', 'Business Development', 
'Incentives', 'Business Development', 
'Locate a Business to Florida', 'Business Development', 
'Minority and Small Business Financing', 'Business Development', 
'Rural Florida', 'Business Development', 
'Small Business Assistance', 'Business Development', 
'About Enterprise Florida - EFI Investor Relations', 'External Affairs', 
'About Enterprise Florida - EFI Partner / Stakeholder', 'External Affairs', 
'About Enterprise Florida - General Questions', 'External Affairs', 
'Stakeholder Council Membership', 'External Affairs', 
'Africa Trade Expansion Program', 'International Trade & Development', 
'Export and Trade Assistance', 'International Trade & Development', 
'Trade Show Information', 'International Trade & Development', 
'About Enterprise Florida - EFI Leadership', 'Marketing & Communications', 
'About Enterprise Florida - Press Inquiry', 'Marketing & Communications', 
'About Enterprise Florida - Public Records Request', 'Marketing & Communications', 
'Buildings & Sites / GIS', 'Marketing & Communications', 
'Marketing Inquiry', 'Marketing & Communications', 
'Sponsorship Opportunity', 'Marketing & Communications', 
'Subscriptions & Newsletters', 'Marketing & Communications', 
'Website/Tech Support', 'Marketing & Communications', 
'Florida Defense Alliance & FDSTF', 'Military & Defense', 
'International Offices - Enterprise Florida', 'International Offices', 
NULL)



Please like and mark this as best answer if you find it positive.

Regards,
Jolly Birdi

All Answers

Jolly_BirdiJolly_Birdi
Hello @Kathleen

Please try this below Code:
  
CASE( Subject__c , 'Career Opportunities with Enterprise Florida', 'Administration - Human Resources', 
'Vendor Inquiry', 'Administration - Human Resources', 
'Sports', 'Administration - Salesforce', 
'Data & Statistics', 'Business Development', 
'Expand an Established Florida Business', 'Business Development', 
'Florida Industry Information', 'Business Development', 
'Foreign Direct Investment (FDI)', 'Business Development', 
'Incentives', 'Business Development', 
'Locate a Business to Florida', 'Business Development', 
'Minority and Small Business Financing', 'Business Development', 
'Rural Florida', 'Business Development', 
'Small Business Assistance', 'Business Development', 
'About Enterprise Florida - EFI Investor Relations', 'External Affairs', 
'About Enterprise Florida - EFI Partner / Stakeholder', 'External Affairs', 
'About Enterprise Florida - General Questions', 'External Affairs', 
'Stakeholder Council Membership', 'External Affairs', 
'Africa Trade Expansion Program', 'International Trade & Development', 
'Export and Trade Assistance', 'International Trade & Development', 
'Trade Show Information', 'International Trade & Development', 
'About Enterprise Florida - EFI Leadership', 'Marketing & Communications', 
'About Enterprise Florida - Press Inquiry', 'Marketing & Communications', 
'About Enterprise Florida - Public Records Request', 'Marketing & Communications', 
'Buildings & Sites / GIS', 'Marketing & Communications', 
'Marketing Inquiry', 'Marketing & Communications', 
'Sponsorship Opportunity', 'Marketing & Communications', 
'Subscriptions & Newsletters', 'Marketing & Communications', 
'Website/Tech Support', 'Marketing & Communications', 
'Florida Defense Alliance & FDSTF', 'Military & Defense', 
'International Offices - Enterprise Florida', 'International Offices', 
NULL)



Please like and mark this as best answer if you find it positive.

Regards,
Jolly Birdi
This was selected as the best answer
Kathleen Munetz-Vasquez 3Kathleen Munetz-Vasquez 3
Thanks Jolly, worked like a charm!