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...
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?)
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
back again to the list setting, put back the formula (so still days old is kept) and saved
still list was working
Thanks, but it didn't fix the issue for me.
Replacing the formula with '0' allows list to work (without the calculation of days, of course) but when I go back and re-insert the formula, I have the same error and issue.
- true... the issue came back after a couple of inserts again. Well leave to 0 ( i did the same) as a workaround. I'd also try to create a new column with days old to see if it works. I hope this gets fixed on the list itself; that's really weird it seems that a data type or function it got changed.
- issue cam back again even with 0. I've deleted the column "Days Old" completely