Jun 21 2021 08:40 AM
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?!