About SharePoint column validation

R N 0 Reputation points
2024-04-25T09:35:24.35+00:00

This is a question about setting up columns in SharePoint. I would like to enter a formula in "Column Validation" so that input other than the standard text will be invalidated. There are several standard wordings, but what kind of formula should I enter?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,682 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,675 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Haoyan Xue_MSFT 19,871 Reputation points Microsoft Vendor
    2024-04-29T05:52:58.9466667+00:00

    Hi @R N ,

    Thank you for your detailed response and time.

    Using the following formula(text is my column name, please replace it with your column name.):

    =OR(text="Product A",text="Product B",text="Product C")

    User's image

    Note: The comparison is not case sensitive.

    SharePoint column validation supports a subset of Excel functions. While not all Excel functions are available, you can use common functions like AND, OR, IF, ISBLANK...

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.