Forum Discussion
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...
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
I noticed that it was working from my phone browser but not from my laptop, if it helps to troubleshoot
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
Where did you set the default to '0' ?
- 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
