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
- Same issue with a brand new list. Added 2 items, and now it returns the error whenever I try to add something.
Jakub_Wolak
We had the same problem and it started off around March 11, 2022.
The error reads validation failed when evaluating formulas so I went and deleted the only column which was calculated under list settings. It seems to me that the formula has gone wrong or not working anymore as we had not created this column and were using the list from the template. After we deleted this column, it was working fine again.- Same here. Following this for the resolution.
Jakub_Wolak Same issue here with a new list based off the Issues list. Tried to add new columns and get "Error: Column validation failed when evaluating formulas" even with just a text only column
Experiencing the same issue after modifying my SP list. Thanks for sharing useful information
- Also having this issue, we are on office 365 here if that matters.
I have been using this same sharepoint task entry screen daily and now it errors out? - Hello I have the same exact situation. Have you gotten any fix
