function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
utz1utz1 

Formula to check checkbox only if field is changed

Hello,
i want to write entry criteria where I want if value is changed then only checkbox field is updated to true. Now if Latest update is blank and we put anything in to it then also it checkes the checkbox. I want If Latesr Update field is filled and we changed it then only checkbox get checked


AND( OR(ISPICKVAL( Reason , "Support-Outage"),ISPICKVAL( Reason , "Support-Supplier Maintenance")) ,   AND( LEN(Latest_Update__c  ) <> 0 ,ISCHANGED( Latest_Update__c  ))   ,  OR(Entitlement.Name  =  "MSO Entitlement Process",Entitlement.Name  =  "Planned Maintenance Process"))
RD@SFRD@SF
Hi utz1,

Try this formula
  
AND(
		OR(ISPICKVAL( Reason , "Support-Outage"),ISPICKVAL( Reason , "Support-Supplier Maintenance"))
		,AND( 
				NOT(ISBLANK(Latest_Update__c))  ,
				ISCHANGED(Latest_Update__c)
			)   
		,OR(Entitlement.Name = "MSO Entitlement Process",Entitlement.Name="Planned Maintenance Process")
	)

 
utz1utz1
Hi RD@SF,

but its not work even using isblank function

Thanks,
Utz
RD@SFRD@SF
Hi utz,

What is the field type of the field Latest_Update__c?
 
utz1utz1
Hi Deepak, Text Area Long Thanks, Utz