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