Good Morning,
I am trying to set a Validation based on the Assigned To field. I am not sure if it is possible or at least what I have tried so far has not worked. I am hoping that someone can correct my formula so this will work.
Overview
We are using Share Point 2007 to assign tasks which flow from person to person.
Each task flows through a minimum of 4 people [sub]ie(Initiator > Supervisor > Analyst > Inventory Manager)[/sub].
I need the Analyst to be blocked if they try to assign it to the Inventory Manager without the Vendor Lead Time being populated.
Here is the formula that I currently have.
=IF(AND([Assigned To]="SMITH, JOHN"),([Vendor Lead Time] is null),true)
Thank you in advance for any help you can provide.
Clay
I am trying to set a Validation based on the Assigned To field. I am not sure if it is possible or at least what I have tried so far has not worked. I am hoping that someone can correct my formula so this will work.
Overview
We are using Share Point 2007 to assign tasks which flow from person to person.
Each task flows through a minimum of 4 people [sub]ie(Initiator > Supervisor > Analyst > Inventory Manager)[/sub].
I need the Analyst to be blocked if they try to assign it to the Inventory Manager without the Vendor Lead Time being populated.
Here is the formula that I currently have.
=IF(AND([Assigned To]="SMITH, JOHN"),([Vendor Lead Time] is null),true)
Thank you in advance for any help you can provide.
Clay