So this is the current validation rule set up that throws the error:
/*this is a comprehensive list of all text values we want to allow in the "Division" field*/
if(Division="Lightcast",false,
/*Public Sector divisions*/
if(Division="Public Sector",false,
if(Division="EDO",false,
if(Division="National Public Sector",false,
if(Division="State and Local Public Sector",false,
if(Division="Workforce",false,
/*Education divisions*/
if(Division="Education",false,
if(Division="Colleges",false,
if(Division="EDU Partnerships",false,
if(Division="University",false,
/*Global divisions*/
if(Division="Global",false,
/*Enterprise divisions*/
if(Division="Enterprise",false,
if(Division="Enterprise Carlone",false,
if(Division="Enterprise Semmes",false,
if(Division="Enterprise Global",false,
if(Division="Enterprise Mid Market",false,true))))))))))))))))
I'm attempting to re-write it to make it somewhat more complex, but perhaps less clunky. We want the Division field on users to sort of function as if it were a dependent picklist related to the Lightcast Market Vertical field. If we choose "Public Sector" for a user in that Lightcast Market Vertical field, then we want the ONLY acceptable text options in the Division field to be one of the 5 Public Sector text options. Similarly, if we choose "Education" in the Lightcast Market Vertical field, then we want the validation rule to only allow text to be one of those 4 relevant Education text options. Etc. Hope that makes sense. Any suggestions?
#Trailhead Challenges