I've got a date column in a view and I'm using a validation formula:

=IF(TEXT([Data documento],"yyyy")="2018",TRUE,FALSE)

So that users can only insert date within the year 2018.

  • I always get an error when saving the formula, how come?
  • One more question, not quite related, should we mainly do validation through Powerapps forms? Is this the best practice that MS is suggesting for sharepoint?

I'm using sharepoint 365

enter image description here enter image description here

I've also tried inserting the formula as Michael Han_MSFT suggested:

=TEXT([Data documento],"yyyy")="2018"

But unfortunately I still get an error message as shown below enter image description here enter image description here

2 Answers 2


You need change the validation formula to this:

=TEXT([Data documento],"yyyy")="2018"

Try to use this in list validation. Go to list settings-> validation settings:

enter image description here

  • still getting an error message: "Sorry, something went wrong The formula contains a syntax error or is not supported". Is there some kind of debugger we could use? The only way I can sudo replicate the formula is in Excel.
    – Luther
    Commented Apr 12, 2019 at 2:03
  • Per my test, it works and I didn't get any errors. Make sure you enter the formula correctly. Commented Apr 12, 2019 at 2:36
  • Thanks for the response, unfortunately I still get an error message. For what It's worth I've updated the question with the image of the error. I have a love/hate feeling towards sharepoint.
    – Luther
    Commented Apr 12, 2019 at 11:45
  • It's strange. Besides, you could try to use list validation instead of column validation and see if it work. I've updated the answer. Commented Apr 15, 2019 at 7:12

Please try using below formula:


I tried using TEXT(created,"yyyy")="2018"

Please do it on list validation. by going through List Setting-->Validation Setting.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.