The ##CASE formula is used to evaluate an input value against a series of cases (conditions) and return a corresponding result. It's similar to a switch-case statement in programming or a series of if-else conditions, providing a compact and readable way to map values.
The syntax would be : ##CASE (fields, value1, result1, value2, result2, default result);
Example:
##CASE("Departmentcode", 'East', 1, 'Vest', 2, 'North', 3, 99)Formula breakdown:
The ##CASE formula can be also used in combination with other formulas such as ##DBLOOKUP, #ISEMAIL, #ISPHONE, etc. Here are a couple of additional examples:
##CASE(ISEMAIL("E-Mail"),1,"E-Mail",SKIPFIELD())##CASE(ISPHONE(PrimaryContactPhone),1,PrimaryContactPhone,SKIPFIELD())