Calculated Column in SharePoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-2466331%22%20slang%3D%22en-US%22%3ECalculated%20Column%20in%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2466331%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20got%20a%20list%20in%20SharePoint%20that%20has%20some%20calculated%20columns%20and%20two%20of%20them%20are%20no%20longer%20working!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%5BEmployers%20Liability%5D%26gt%3BTODAY()%2C%22Yes%22%2C%22No%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%5BPublic%20Liability%5D%26gt%3BTODAY()%2C%22Yes%22%2C%22No%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20were%20working%20when%20I%20created%20the%20list%20and%20published%20it%20to%20the%20business%20but%20they%20are%20no%20longer%20working!%20These%20two%20columns%20then%20feed%20into%20another%20calculated%20column%20to%20work%20out%20whether%20a%20Contractor%20is%20approved%20or%20not%20to%20come%20onto%20site.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(%5BAnnual%20pack%20days%20diff%5D%26gt%3BTODAY()%2C%5BEmployers%20Liability%20expired%3F%5D%3D%22No%22%2C%5BPublic%20Liability%20expired%3F%5D%3D%22No%22%2C%5BHSE%20Database%20Checked%5D%3DTRUE)%2C%22Yes%22%2C%22No%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20other%20columns%20in%20the%20above%20are%20working%20still%20just%20the%20two%20I%20mentioned%20at%20the%20beginning.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2466331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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