I want to build a custom formula field on the Case object. I have a picklist field called Efforts. Picklist field values are 1 min, 15 min, 30 min, 1 hour, 2 hours, 4 hours, 1 day, More than 1 day
I am building the formula field like below.
Formula Field(Number) - Return type is number.
Formula Field =
CASE(
TEXT(Effort__c ),
"5 min", 5,
"15 min", 15,
"30 min", 30,
"1 hour", 60,
"2 hours", 120,
"4 hours", 240,
"More than 1 day", 960,
"1 day", 480,
0
)
The problem is whenever the field Effort__c is null then this formula field is showing the value 0 (as an else condition in the CASE
). I want this to be null if the picklist is null.
I've checked Treat blank fields as blanks
Any help is appreciable thanks!