Calculated Column in SharePoint list

Occasional Visitor

Hi all,

 

I've got a list in SharePoint that has some calculated columns and two of them are no longer working!

 

=IF([Employers Liability]>TODAY(),"Yes","No")

 

=IF([Public Liability]>TODAY(),"Yes","No")

 

Both were working when I created the list and published it to the business but they are no longer working! These two columns then feed into another calculated column to work out whether a Contractor is approved or not to come onto site. 

 

=IF(AND([Annual pack days diff]>TODAY(),[Employers Liability expired?]="No",[Public Liability expired?]="No",[HSE Database Checked]=TRUE),"Yes","No")

 

The other columns in the above are working still just the two I mentioned at the beginning.

 

Any ideas?! 

0 Replies