You need to sign in to do that
Don't have an account?
Jamie Arias
Need help with Error: Syntax error. Missing
So far this is what I have come up with
AND(ispickval('Status' NOT, "none"), Len(Text(App))=0 ))
I'm trying to create a validation rule that will not allow a user to create a new case if the 'App' doesn't have an option selected. The 'status' field is a pick list as well as the 'app' field. When a case is created the status by default is new
AND(ispickval('Status' NOT, "none"), Len(Text(App))=0 ))
I'm trying to create a validation rule that will not allow a user to create a new case if the 'App' doesn't have an option selected. The 'status' field is a pick list as well as the 'app' field. When a case is created the status by default is new
AND ( ISPICKVAL(App__c, ''), ISPICKVAL(Reason, '' ),
OR ( ISPICKVAL(Status, 'Closed-Duplicate'), ISPICKVAL(Status, 'Closed-Resolved'), ISPICKVAL(Status, 'Closed-Not resolved'), ISPICKVAL(Status, 'Closed-Not feasible') )
)
Try now?
All Answers
Only for new cases - AND ( ISNEW(), ISPICKVAL(App__c, '') )
For new & existing cases - Better make the field mandatory from Page Layout or from Field Level.
I don't see why you need to use/check for Status values. Let me know if this works.
--
Abhi
Try below in your validation rule
AND(ISBLANK(Text(Status)),ISBLANK(Text(App__c)))
Let me know for any issues.
Thanks
Arpit
Please mark this answer as SOLVED and BEST ANSWER if it helps you.
AND (IsClosed(), ISPICKVAL(Reason, '') )
but I get the following:
Error: Unknown function IsClosed. Check spelling.
If my understanding is right, you want to make App & Case Reason fields to be mandatory when Status value is Closed-Resolved, Cloased-Not Resolved, Closed-Not feasible ? If yes, then try the following..
AND ( ISPICKVAL(App__c, ''), ISPICKVAL(CaseReason, '' ),
OR ( ISPICKVAL(Status, 'Closed-Resolved'), ISPICKVAL(Status, 'Closed-Not resolved'), ISPICKVAL(Status, 'Closed-Not feasible'))
)
I don't understand what is the use case of ISNEW() now, hence removed.
If you are able to understand what I have given/replied, I guess you can modify your validation rule according to your need. Please let me know if you need any more clarifications.
--
Abhi
There are 2 ways -
--
Abhi
Error: Syntax error. Missing ')'
your formula worked, but when I modified I got the error, where am I missing the ')'?
I used the following,
AND ( ISPICKVAL(App__c, ''), ISPICKVAL(Reason, '' ),
OR ( ISPICKVAL(Status, 'Closed-Duplicate')( ISPICKVAL(Status, 'Closed-Resolved'), ISPICKVAL(Status, 'Closed-Not resolved'), ISPICKVAL(Status, 'Closed-Not feasible')))
)
AND ( ISPICKVAL(App__c, ''), ISPICKVAL(Reason, '' ),
OR ( ISPICKVAL(Status, 'Closed-Duplicate'), ISPICKVAL(Status, 'Closed-Resolved'), ISPICKVAL(Status, 'Closed-Not resolved'), ISPICKVAL(Status, 'Closed-Not feasible') )
)
Try now?