Microsoft List Form Column Validation Not Saving

Question

When I try to add a formula to the data validation section on lists, I type it in a click save. The menu then closes and no error message appears. I then go back on to the edit column tab, and check the data validation section, and the formula I have typed has disappeared. Why is this happening, and how can save the formula?

The formula I am entering is: [Date Required]<=(TODAY+21)

I have also tried: =IF([Date Required]<=(TODAY+21),TRUE,FALSE)

Thank you for your help.

Answer 1

Dear Oliver,

Good day!!

I understand your concern and I would like to convey that I have tested the behavior at my end with Column Validation on modern List in the SharePoint Online, where I can reproduce the behavior.

So, I have checked the Service Health dashboard at the Microsoft end, where there is no related incident found.

In this situation, I am sorry to convey that the behavior we are observing is not an expected where the same problem happens even after clearing the Cache of the browser and I believe the problem should be further investigated by the related development team, where they can collect the related HAR logs while reproducing the problem and perform further investigation.

So, I request you to connect with your IT admin of your organization (How do I find my Microsoft 365 admin? - Microsoft Support) and raise a new service request from the Microsoft 365 admin center so that the related development team will connect with you and investigate the issue further.

Reference: Get support - Microsoft 365 admin | Microsoft Learn

Note: We apologize for redirecting you to related development support team because the moderators in this community are limited with the resource for further investigation and to get a quick resolution to your problem, we requested it.

Appreciate your patience and understanding. Have a great day!!

Best Regards,
Sophia