Below is a requirement I am trying to solve.
I created a custom object labeled Judgment that contains the following fields below
Court - Lookup field to Court custom object
State - Formula text field containing formula: text(Court__r.State__c)
Date Test – Date field
Formula Test – Formula date field, view formula below. (Thanks Steve Mo for helping with this formula.)
Date_Test__c +
CASE(State__c,
"Texas", 365,
"Georgia", 730,
"California",1095,
"New York",1460,
"Alabama", 3500,
"Alaska", 3700,
"Arizona", 3800,
"Colorado", 3900,
"Connecticut", 4000,
"Delaware", 4100,
"Florida", 4200,
"Hawaii", 4300,
"Idaho", 4400,
"Illnois", 4500,
"Indiana", 4600,
"Iowa", 4700,
"Kansas", 4800,
"Kentucky", 4900, NULL)
Formula Test2 - Formula date field, view formula below
Date_Test__c +
CASE(State__c,
"Louisiana", 5100,
"Maine", 5200,
"Maryland",5300,
"Massachusetts",5400,
"Michigan", 5500,
"Minnesota", 5600,
"Mississippi", 5700,
"Missouri", 5800,
"Montana", 5900,
"Nebraska", 6000,
"Nevada", 6100,
"New Hampshire", 6200,
"New Jersey", 6300,
"New Mexico", 6400,
"North Carolina", 6500,
"North Dakota", 6600,
"Ohio", 6700,
NULL)
Formula Test3 - Formula date field, view formula below
Date_Test__c +
CASE(State__c,
"Oklahoma", 6800,
"Oregon", 6900,
"Pennsylvania",7000,
"Rhode Island",7100,
"South Carolina", 7200,
"South Dakota", 7300,
"Tennessee", 7400,
"Utah", 7500,
"Vermont", 7600,
"Virginia", 7700,
"Washington", 7800,
"West Virgina", 7900,
"Wisconsin", 8000,
"Wyoming", 8100,
NULL)
Question – Is there a way to merge the Formula Test, Formula Test2, Formula Test3 formula together in one field? I tried to enter all the codes in one formula field, however I had exceeded the compile size limit of 5,000 bytes. If not, is there another method I can do to resolve this requirement?
5 answers
+ Naveen
Forrest,
If you are using Enterprise Edition or higher, you can create a Date field on the Judgment object and update it with one of the three formula field date values (whichever one is not blank)...like this:
