Skip to main content
edited tags
Link
Kris Goncalves
  • 22.8k
  • 8
  • 35
  • 72
Source Link

Formula problem with Multiple Condition

I need help please,

I created two fields, the first is "Group" of text type and the second is "status" of formula type

The status must check the condition of If Group contains '9','MIN','TER', 'CLO', 'closed', then the "status" field is inactive else active

Taking into consideration that this update should not impact all accounts. Only for users of the "App" application who have profiles starting with "App"

==> the formula :

IF( BEGINS( $Profile.Name, "App" ),
  Group__c = "9" , "MIN" ,"TER" , "CLO" , "closed" ,"inactif", "actif")

my question is how to correct my formula so that it respects the condition