IF(TEXT( Product_Brand__c )="Legrand", "Anita",
CASE(RIGHT(CaseNumber,1),
"0","Amol Zambre",
"2","Shweta Agey",
"3","Shweta Agey",
"4","Vrushali Jadhav",NULL))
PFA screenshot also but some time user wants to edit that name is it possible to change that name in case level
showing read-only suggests how can I give edit access to them.
1 answer
Hi Kiran,
A formula never stores a value in the database - the value is always calculated at read-time. This means a formula field cannot possibly ever be editable. This also means you're going to face big problems once any of these people leaves the company - this isn't the correct way to round-robin cases.
If you wanted the formula to be able to show a custom value, then you'll need to create another field. Possibly text or picklist. Then, you can add it to your formula:
BLANKVALUE(Quotation_Maker_Override__c,
IF(TEXT( Product_Brand__c )="Legrand", "Anita",
CASE(RIGHT(CaseNumber,1),
"0","Amol Zambre",
"2","Shweta Agey",
"3","Shweta Agey",
"4","Vrushali Jadhav",NULL)))
