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
Umair Mohammad 10Umair Mohammad 10 

Urggh, keep getting error.

AND(
$UserRole.Name <> 'System Administrator',
$Setup.Migration_Admin__c.AdminId__c <> $User.Id,
CASE( RecordType.Name ,
'Rental', 1,
'Retail', 1,
'Corporate/System Help', 1,
'Customer Experience-Quiq', 1,
'Custom'
0 ) = 1,
OR(
AND(
TEXT(Status) = 'Solved',
OR(
ISBLANK(TEXT(tb_Type__c)),
ISBLANK(TEXT(tb_Category__c))
)
)
I keep getting an error, whcih is attached in this post. User-added image
Need assistance, please
 
AnkaiahAnkaiah (Salesforce Developers) 
Hi Umair,

try with below. 
AND(
$UserRole.Name <> 'System Administrator',
$Setup.Migration_Admin__c.AdminId__c <> $User.Id,
CASE( RecordType.Name ,
'Rental', 1,
'Retail', 1,
'Corporate/System Help', 1,
'Customer Experience-Quiq', 1,
'Custom'
0 ) = 1,
OR(
AND(
TEXT(Status) = 'Solved',
OR(
ISBLANK(TEXT(tb_Type__c)),
ISBLANK(TEXT(tb_Category__c))
)
)))

If this helps, Please mark it as best answer.

Thanks!!
Khakan IspakhevKhakan Ispakhev
I suppose you forgot a comma and couple brackets
Please try this code:
AND(
$UserRole.Name <> 'System Administrator',
$Setup.Migration_Admin__c.AdminId__c <> $User.Id,
CASE( RecordType.Name ,
'Rental', 1,
'Retail', 1,
'Corporate/System Help', 1,
'Customer Experience-Quiq', 1,
'Custom',
0 ) = 1,
OR(
AND(
TEXT(Status) = 'Solved',
OR(
ISBLANK(TEXT(tb_Type__c)),
ISBLANK(TEXT(tb_Category__c))
)
)
))
Shri RajShri Raj
AND(
$UserRole.Name <> 'System Administrator',
$Setup.Migration_Admin__c.AdminId__c <> $User.Id,
CASE(RecordType.Name,
'Rental', 1,
'Retail', 1,
'Corporate/System Help', 1,
'Customer Experience-Quiq', 1,
0
) = 1,
OR(
AND(
TEXT(Status) = 'Solved',
OR(
ISBLANK(TEXT(tb_Type__c)),
ISBLANK(TEXT(tb_Category__c))
)
)
)
)

 
Amidou CisseAmidou Cisse
It's difficult to know exactly what the error is without additional information. However, it seems that the formula expression has some syntax errors. Here are a few things to check:
Make sure there are no missing parentheses or quotes in the formula
Make sure that each case statement has a value specified, even if it's just 0
Check that each logical operator (AND, OR, etc.) has the correct number of arguments.