I've got the following fields that I'm trying to put into a validation rule:
- Date1
- Date2
- Picklist1
- Picklist2
Here's what I want it to do - When Date1 is populated, I want to require Date2, Picklist1 and Picklist2. Here's the validation formula I've created. The problem is that it's giving me an incorrect number of parameters error for IF()
IF(NOT(ISBLANK( Date1 )),
IF(ISBLANK(TEXT( Picklist1 )),
IF(ISBLANK( Date2 ) ,
IF(ISBLANK(TEXT( Picklist2 )) ,
NULL))))
I'd appreciate some assistance! Thank you!
답변 2개
Brent, here you go:
AND (
NOT(ISBLANK(Date1)),
OR(
ISBLANK(TEXT( Picklist1)),
ISBLANK(Date2) ,
ISBLANK(TEXT( Picklist2 ))
)
)
And that's it!
