Skip to main content
Topics#FormulasPregunta de Jamie Arias
Jamie Arias (Build it Green) preguntó en #Formulas
3 ene 2018, 23:24

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

 
11 respuestas
  1. Abhilash Kuntar (OSF Digital)
    4 ene 2018, 18:25
    Its easier when you indent/format it

    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?
Escribir una respuesta...
0/9000