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

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?)
  - fabiopaolo
    Copper Contributor
    Mar 17, 2022
    yes put 0 and saved. List started to work again
    back again to the list setting, put back the formula (so still days old is kept) and saved
    still list was working