I'm wanting to create a column that will provide a yes or no answer depending on some other conditions.
I thought I found something that was going to work but it didn't.
So basically Annual pack days diff needs to be greater than todays date and Public Liability expired needs to be equal to No as well as Employers Liability expired. All the conditions need to be met for it to return Yes. If one is wrong then No needs to be returned.
=IF(OR([Annual pack days diff]> Today(), AND ([Public Liability expired?] = "No", ([Employers Liability expired?] ="No")), "Yes", "No"))