Formula for multiple conditions

Occasional Visitor

Hi,

 

In the attached image below, i am trying to enter a formula to make a person Not Available for the below criteria.

 

rizwanulhasan_2-1641057188149.png

 

 

rizwanulhasan_1-1641057167458.png

 

The person A should not be available if:

 

1. The DND status (Sheet2) of person A is Do Not Disturb.

2. The status of person A is pending (Sheet 1).

3. Person A has 2 or more status as Completed.

 

Can someone guide me with the formula.

 

Thanks in advance.

1 Reply