function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
B D 263B D 263 

IF , ISBLANK and ISPICKVAL together

Hello Friend, 
i need to create formula field to capture the name of the person who is changing the case status from Open to In Progress , only in the cases when the formula field is empty, the below formula does not work
Please help
IF( AND( ISPICKVAL(Status, In progress) , ISBLANK(Incharge__c)), TEXT(LastModifiedById),0)
Thanks,
BD
Best Answer chosen by B D 263
ANUTEJANUTEJ (Salesforce Developers) 
Hi there,

I was able to use a simple process builder on the case to update  the in charge field and I was able to implement this similar use case, below are screenshots for the same:

User-added image

User-added image

User-added image

Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.  

Thanks.