Sharepoint column validation disappears

Question

So I'm busy with a sharepoint list where I want to apply some validation to a text field. I type in my validation formm just a simple one from a tutorial, like this:

[ArN]="G10"

Now, if I type it in an other way, like this:

=[ArN]="G10"

It comes with a syntax error.

If I try to write the next one:

=ISNUMBER([TestNum]+0)

Sharepoint accepts my column and this syntax, but if I change anything, for example I change '0' to '1' and BEFORE try to save I change it back to '0', it won't accept it anymore and comes back with a syntax error.

Also, if I write something it has been accepted during save, when I go back to change it, my form will be disappeared. I don't know what I'm doing wrong, I followed several tutorials, but for them it was easy. For me it doesn't work at all.

Answer 1

Dear Sophia,

Thank you for your fast response and I will follow your instructions and contact our IT department.

Have a great day!

Sincerely,

Istvan Kokuti

Answer 2

Dear Istvan Kokuti,

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