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
avinash dhankeavinash dhanke 

implement validation rule on Account like if revenue is > 5000 then make at least one field mandatory and if its > 10000 then make at least 2 other fields including previous one. Validation rule will pop up at top of the page..any solution

Best Answer chosen by avinash dhanke
Arpit Jain7Arpit Jain7
Hello Avinash,

Try below validation rule

(AnnualRevenue>10000 && (ISBLANK(Description) || ISBLANK(NumberOfEmployees)))||( AnnualRevenue>5000 && ISBLANK(Description))

Let me know for any further issues. Mark it as solved if it helps.

Thanks
Arpit

All Answers

Ashish DevAshish Dev
Hi Avinash,

This can be implemented in multiple ways. One is shown below.
  
IF( AnnualRevenue > 10000,  ISBLANK(Description) &&  ISBLANK(NumberOfEmployees)  ,  IF(AnnualRevenue > 5000, ISBLANK(Description), false) )

Let me know if this helps you.
avinash dhankeavinash dhanke
hi ashish,
can you give mi alternate solution...
avinash dhankeavinash dhanke
in firstcase revenue>5000 is ok is executed but revenue>10000 is that 2 any other field manditory in that you give mi code  is i will put value in numbur of emplyee the recored is save not error msg ...
 
Arpit Jain7Arpit Jain7
Hello Avinash,

Try below validation rule

(AnnualRevenue>10000 && (ISBLANK(Description) || ISBLANK(NumberOfEmployees)))||( AnnualRevenue>5000 && ISBLANK(Description))

Let me know for any further issues. Mark it as solved if it helps.

Thanks
Arpit
This was selected as the best answer
avinash dhankeavinash dhanke
thanks arpit..