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
Murali Krishna 381Murali Krishna 381 

If Start Date is greater than today the Project Status cannot be any status other than Not Started. how can we write validation rule for this

If Start Date is greater than today
the Project Status cannot be any status
other than Not Started.
how can we write validation rule for this?
 
Best Answer chosen by Murali Krishna 381
CharuDuttCharuDutt
Hi Murali
Try Below Validation 
AND(Startdate__c>TODAY(), NOT(ISPICKVAL(Status, 'Not Started')))
Please Mark It As Best Answer If It Helps
Thank You!
 

All Answers

Trailblazer7Trailblazer7
Try the below syntax with proper error message of your choosing 
AND( Startdate > TODAY(), !ISPICKVAL(Status, 'Not Started'))

 
Suraj Tripathi 47Suraj Tripathi 47

Hi,

Please find the solution.

 

Creating a Validation Rule
From Setup, go to Object Manager and click Account.
In the left sidebar, click Validation Rules.
Click New.

AND(Startdate__c>TODAY(), !ISPICKVAL(Status, 'Not Started'))

Please mark it as the Best Answer 

Thank You
Suraj Tripathi 47Suraj Tripathi 47

Hi,

Please find the solution.

 

Creating a Validation Rule
From Setup, go to Object Manager and click Account.
In the left sidebar, click Validation Rules.
Click New.

AND(Startdate__c>TODAY(), !ISPICKVAL(Status, 'Not Started'))

Please mark it as the Best Answer 

Thank You
Murali Krishna 381Murali Krishna 381
Thanks for your help guys

 
CharuDuttCharuDutt
Hi Murali
Try Below Validation 
AND(Startdate__c>TODAY(), NOT(ISPICKVAL(Status, 'Not Started')))
Please Mark It As Best Answer If It Helps
Thank You!
 
This was selected as the best answer