You need to sign in to do that
Don't have an account?
Megan Hooser 7
Formula help, if/case
Have the following forumla, I've tried writing a few different ways, of case or if and not sure what to do to correct. I need to evaluate the picklist for a checkbox, marking true for values listed, or else leave unchecked
IF(OR(ISPICKVAL(Unit_Type__c,
"Chiller Air Cooled <10T",
"Chiller Air Cooled 10-50T",
"Chiller Air Cooled >50T",
"Chiller Water Cooled <10T",
"Chiller Water Cooled 10-50T",
"Chiller Water Cooled >50T",
"Computer Room Air Conditioning Unit",
"Cond/Outdoor Unit",
"Cooler/Freezer",
"Cooling Tower <10T",
"Cooling Tower 10-50T",
"Cooling Tower >50T",
"ERV/HRU",
"Heat Exchanger Brazed Plate",
"Heat Exchanger Plate & Frame",
"Heat Exchanger Shell & Tube",
"RTU <5T",
"RTU 5T-15T",
"RTU 15-30T",
"RTU 30T+", TRUE, FALSE)
Error: Syntax error. Missing ')'
IF(OR(ISPICKVAL(Unit_Type__c,
"Chiller Air Cooled <10T",
"Chiller Air Cooled 10-50T",
"Chiller Air Cooled >50T",
"Chiller Water Cooled <10T",
"Chiller Water Cooled 10-50T",
"Chiller Water Cooled >50T",
"Computer Room Air Conditioning Unit",
"Cond/Outdoor Unit",
"Cooler/Freezer",
"Cooling Tower <10T",
"Cooling Tower 10-50T",
"Cooling Tower >50T",
"ERV/HRU",
"Heat Exchanger Brazed Plate",
"Heat Exchanger Plate & Frame",
"Heat Exchanger Shell & Tube",
"RTU <5T",
"RTU 5T-15T",
"RTU 15-30T",
"RTU 30T+", TRUE, FALSE)
Error: Syntax error. Missing ')'
pcon
If the type of the formula field is a checkbox, you'll want to do