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!
