Hi,

 

i'm new to salesforce. I want to update a readonly field with a flag of true, only if one or more of some selected fields are updated in account. This is applicable only for update operation and not for new operation.

Below is the formula i'm trying to use but i'm getting the ERROR: Function ISCHANGED may not be used in this type of formula". All the "source MSAG fields" are of text type.

 

MSAG_UPDATE=

(formula below)

IF(AND(OR(
 ISCHANGED(MSAGServiceBuilding__c),
 ISCHANGED(MSAGServiceCity__c),
 ISCHANGED(MSAGServiceCommunity__c),
 ISCHANGED(MSAGServiceCountry__c),
 ISCHANGED(MSAGServiceFloor__c),
 ISCHANGED(MSAGServiceHouseNumber__c),
 ISCHANGED(MSAGServiceHousePrefix__c ),
 ISCHANGED(MSAGServiceHouseSuffix__c ),
 ISCHANGED(MSAGServicePostalCode__c ),
 ISCHANGED(MSAGServicePostDirectional__c ),
 ISCHANGED(MSAGServicePreDirectional__c ),
 ISCHANGED(MSAGServiceRoom__c ),
 ISCHANGED(MSAGServiceState__c ),
 ISCHANGED(MSAGServiceStreetName__c ),
 ISCHANGED(MSAGServiceStreetSuffix__c ),
 ISCHANGED(MSAGServiceSuite__c )),(NOT(ISNEW()))),
 TRUE,FALSE
)

 

I would appreciate your help. Thanks.

 

Regards,
Dipil Jain

Hi,

 

i'm new to salesforce. I want to update a readonly field with a flag of true, only if one or more of some selected fields are updated in account. This is applicable only for update operation and not for new operation.

Below is the formula i'm trying to use but i'm getting the ERROR: Function ISCHANGED may not be used in this type of formula". All the "source MSAG fields" are of text type.

 

MSAG_UPDATE=

(formula below)

IF(AND(OR(
 ISCHANGED(MSAGServiceBuilding__c),
 ISCHANGED(MSAGServiceCity__c),
 ISCHANGED(MSAGServiceCommunity__c),
 ISCHANGED(MSAGServiceCountry__c),
 ISCHANGED(MSAGServiceFloor__c),
 ISCHANGED(MSAGServiceHouseNumber__c),
 ISCHANGED(MSAGServiceHousePrefix__c ),
 ISCHANGED(MSAGServiceHouseSuffix__c ),
 ISCHANGED(MSAGServicePostalCode__c ),
 ISCHANGED(MSAGServicePostDirectional__c ),
 ISCHANGED(MSAGServicePreDirectional__c ),
 ISCHANGED(MSAGServiceRoom__c ),
 ISCHANGED(MSAGServiceState__c ),
 ISCHANGED(MSAGServiceStreetName__c ),
 ISCHANGED(MSAGServiceStreetSuffix__c ),
 ISCHANGED(MSAGServiceSuite__c )),(NOT(ISNEW()))),
 TRUE,FALSE
)

 

I would appreciate your help. Thanks.

 

Regards,
Dipil Jain

Hello,

I am trying to create a workflow on object "Cases". I have a look up field on Cases called Internal_Originator_c. I want to notify this person whenever the case ownership changes. In the workflow formula, I am writing ISCHANGED(OwnerID) but I am getting the following error.

Error: Function ISCHANGED may not be used in this type of formula

Why? Can someone sugget a better solution, please? I really appreciate the help.