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