Been stumped on this issue for a while. Will appreciate if someone can point me in the right direction.
I have a custom field (date type: percent) named %.
When user selects a milestone percentage (qual OR quant), the % field should automatically auto-populate with the percentage chosen.
Milestone percentage (qual/quant) is a picklist field. In screenshot attached, since milestone percentage qual is selected, % field should populate as 75.0% as well.
Can a formula do the trick? Or i need to create a workflow rule? Any help is appreciated!
13 个回答
Try this: CASE(Teams__c, 'Qual,
Case(Milestone_Percentages_Qual__c, '0.0%', 0,
'20.0%', 20,
'35.0%', 35,
'42.5%', 42.5,
'50.0%', 50,
'57.5%', 57.5,
'65.0%', 65,
'75.0%', 75,
'90.0%, 90,
'100.0%', 100, 0)
,'Quant,
Case(Milestone_Percentages_Qual__c, '0.0%', 0,
'15.0%', 15,
'20.0%', 20,
'32.5%', 32.5,
'45.0%', 45,
'57.5%', 57.5,
'70.0%', 70,
'80.0%', 80,
'90.0%, 90,
'100.0%', 100, 0)
,0)
