The Or formula works like the And formula but is used to determine whether any conditions of the test are true rather than all. The difference between the And function and the Or function is that the And function will only display results when all of the conditions are true whilst Or will display results when any of the conditions are true.
Unlike the And Formula, the Or formula can select two different results from the same column (it can also be applied to different columns). For instance, the Or formula can be used to display Requests where the status is equal to Awaiting Build or equal to Initial Approval. This is not possible with the And function because a Request cannot be in two statues at once.
The filter can be set up so that results where the status is equal to Awaiting Build or Initial Approval.
Click Apply and the table will filter data and only display results where the status is equal to Awaiting Build or Initial Approval.
