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 validation failed when evaluating formulas
Here is what I have tried:
- Another person to add/edit an item (they can)
- Restarting my computer and logging out/into my account
- Making sure my system is up to date
- Clearing my cache
- Editing existing items in the list (doesn't let me save it - I get the error)
- Accessing the list from an Apple Device (I can add/edit)
I have not played around with any of the settings or formulas. I am putting in the same values as I did before. This error simply came out of "no where". Any advice or tips what to try next?
Thank you in advance!
38 Replies
Hi,
In the formula =IF(LEN([Date reported])=0,0,DATEDIF([Date reported],TODAY(),"d"))
I replaced the "d" for "D" and this solved my issue.
The working formula (in my case) will be like this
=IF(LEN([Date reported])=0,0,DATEDIF([Date reported],TODAY(),"D"))
Hope this helps.
- Sorry, the error is back.
- Esto también vale para las fórmulas en español,
en la fórmula de DÃas de antigüedad,
=IF(LEN([Fecha de notificación])=0;0;SIFECHA([Fecha de notificación];TODAY();"d"))
si se cambia la "d" por "D" se soluciona (en mi caso) el problema.
La fórmula final quedarÃa asÃ
=IF(LEN([Fecha de notificación])=0;0;SIFECHA([Fecha de notificación];TODAY();"D"))
Espero que sirva de ayuda.- Ha vuelto el error, se ha solucionado temporalmente pero ha vuelto.
- 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 troubleshootthank 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' ?
- I wonder if other calculated fields can cause this same error? We only had the Days Old calculated field and removing that fixed it for me.
For me the issue is happening in both browsers Chrome and edge and can't even find the Days Old Column in the list settings
- Same issue stemming from Issue Tracker template used in Teams. Still getting error after deleting Days Old column. Following for resolution
- Deleting our Days Old calculation fixed my issue. Thanks to all for your input on this.
I did have this issue in both Edge and Chrome browsers. All fixed now.Thank you Mr bboes-SSteel !, i could solve the problem, il try to erase the validation section of that column but i can't, so i most to erase all the column
- Hi , will like to know how you delete the Days Old in the current format? I try to edit but cannot
- Go to List Settings from top right (settings gear). There you will have a column options and from there look for Days Old, it will show you as calculated. Delete it
This appears to be an issue arising from the Microsoft edge browser update. Version 99.0.1150.39: March 10
Error does not appear in Chrome.
- Thanks for your input!
- Agreed - this appears to have started recently with that version of Edge, and Chrome still works fine.
- Solution: Hello, I found out as I delete in template of task list the calculated column called as Days old or smth like that, my issue was solved. I hope that it helps also all of you.
- Thank you!
- This helped me. I deleted the Days Old column. that fixed the issue for us. Thank you!!!
- Same issue here and began on 11MAR22.
Odd thing is co-worker copied and reused my list and hers is still working. I compared calculated field formulas and they are the same. I hate to delete the field that was suggested by Pradeep_Kumar2205 (it is useful) -- any other suggestions that worked? (Could the field be added back after deletion with the same formulas? ) - I have the same issue. I have my SharePoint list added to Teams. When someone tries to add a new item via TEAMS they get the error. So they open via SharePoint and they can add an item. Others cannot add an item using either method. This is a fairly new Issue Tracker list, and has been working fine until last week.
Please help.
