Forum Discussion

Copper Contributor

Mar 11, 2022

Error: Column validation failed when evaluating formulas [Need Assistance]

Hello, I have a SharePoint list that I have been using and it has been working fine. The next day I go on, and I get the following message when trying to add or edit an item: Error: Column v...

SharePoint Online

AdrienVer

Copper Contributor

Mar 16, 2022

Same issue here, for some reason it just occured. I deleted the calculated counting the number of days old and it is fixed. Not sure why it bugs as I didn't changed anything in the list.

I noticed that it was working from my phone browser but not from my laptop, if it helps to troubleshoot

fabiopaolo

Copper Contributor

Mar 17, 2022

thank you AdrienVer this worked for me. I tried all browsers, after a couple of successfull items entered, they all have the same problem, no new items can be entered with the Error of column validation.

The default date get stuck (e.g. date reported) to 11th March. I believe there is an issue on the Microsoft List itself and i hope Microsoft support can look into it.

The code of Days Old is:

=IF(LEN([Date reported])=0,0,DATEDIF([Date reported],TODAY(),"d"))

I put to default as 0 and it resolved the issue. I'm now able to enter again.

I also put back the calculation code again and seems to work.

Nice spot AdrienVer

ABonner88
Copper Contributor
Mar 17, 2022
fabiopaolo :
Where did you set the default to '0' ?
- fabiopaolo
  Copper Contributor
  Mar 17, 2022
  if you are using microsoft lists, open the list, top right click on the settings wheel, then on "List settings". Identify the column name, click on it, you'll see the formula
  - ABonner88
    Copper Contributor
    Mar 17, 2022
    fabiopaolo
    Yes-- I see the formula in the 'Days Old' column settings; the formula you posted above is the same as I have. But you said you changed default to '0'-- where did you change that? (In the formula? In the 'Date Reported' column?)