The values are;
Report
Dashboard
Email Template
Field
Case Type
Page Layout
Othe (please specify)
I would like to auto populate the field with a number based on the above values;
Report 2.25
Dashboard 4.75
Email Template 2.50
Field 1.25
Case Type 2.50
Page Layout 2.50
Othe (please specify) 2.00
Can anyone suggest the formula I need to write to achieve this please?
5 réponses
Give this a try: CASE(Change_Type__c,
"Report", 2.25,
"Dashboard", 4.75,
"Email Template", 2.50,
"Field", 1.25,
"Case Type", 2.50,
"Page Layout", 2.50,
"Other (please specify)", 2.00,
0)
PS. Double-Check the spelling and punctuation of the picklist values so the Formula matches exactly
