You need to sign in to do that
Don't have an account?
Formula exceeding character limit
Hi
I am using following formula for a custom field. But it is exceeding character limit. Any help would be greatly appreciated.
IF(
AND(
CO_of_Inverters_2__c > 0 , NOT( ISBLANK( TEXT( CO_Inverter_Model_2__c ) ) ) ,NOT( ISBLANK( TEXT( CO_Inverter_Model_3__c ) ) )
),
TEXT( CO_of_Inverters__c ) &" "& TEXT( CO_Inverter_Model__c ) &" & " &TEXT( CO_of_Inverters_2__c ) &" "& TEXT( CO_Inverter_Model_2__c )&" & " &TEXT( CO_of_Inverters_3__c ) &" "& TEXT( CO_Inverter_Model_3__c ) &" inverters" ,
IF(
AND(
CO_of_Inverters_2__c > 0 , NOT( ISBLANK( TEXT( CO_Inverter_Model_2__c ) ) )
),
TEXT( CO_of_Inverters__c ) &" "& TEXT( CO_Inverter_Model__c ) &" & " &TEXT( CO_of_Inverters_2__c ) &" "& TEXT( CO_Inverter_Model_2__c ) &" inverters",
TEXT( CO_of_Inverters__c )&" "& TEXT( CO_Inverter_Model__c ) &" inverters"
)
)
Are the fields you are referring to also formula fields? If so, all the formulas contribute to the total limit. Ideally, you can find a way to reduce the number of times you are referring to formula fields. If not, you may need to do your calculations in a trigger.
--Sarah