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...
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.