Hi there,

I'm hoping someone might be able to help me!

I want to create a custom formula field, which brings back a specific result based on what's been selected from a custom picklist that I've created. Below are picklist values against the results that I need returning.

CPM = 1,000
CPC = 1
CPL = 1
CPA = 1

The custom field that I've created is called Pricing_Metric__c

Any help/guidence would be awesome. I've tried CASE, IF... and the only result I seem to be achieving is a loss of hair, which I'm gradually pulling out!

Thanks,

Paul

Hi there,

I'm hoping someone might be able to help me!

I want to create a custom formula field, which brings back a specific result based on what's been selected from a custom picklist that I've created. Below are picklist values against the results that I need returning.

CPM = 1,000
CPC = 1
CPL = 1
CPA = 1

The custom field that I've created is called Pricing_Metric__c

Any help/guidence would be awesome. I've tried CASE, IF... and the only result I seem to be achieving is a loss of hair, which I'm gradually pulling out!

Thanks,

Paul