I am currently trying to write an equation or a statement that returns a true or false from three columns. What I want to be able to do is check the first two columns to see if they match. If true then check the 3rd column to make sure that the following items are entered are not entered.
2: Intrviewd -Lost Touch
2: Intrviewd -Temp Leave
2: Intrviewd-Dbl Agent
Below is a sample of the data I am using:
|user5_text| |enterby| |CandidStatusName|
|Fully keyworded| |JOSEPH| |2:Intrviewed-phone|
| | | EB| |2: Intrviewd-Phone|
|Hanna| |Hanna| |2: Intrviewd-Phone|
Sorry if its confusing please let me know if you need any clarifaction on anything.