About SharePoint column validation

Question

About SharePoint column validation

R N 0

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?

Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff

2024-04-26T01:53:38.42+00:00

Hi @R N ,

Certainly! In SharePoint, you can use column validation to ensure that input adheres to specific rules. To better help you with your problem, perhaps you could tell me the exact type of column you have and what standard format you wish to implement.
R N 0 Reputation points

2024-04-26T14:32:19.9133333+00:00
R N 0 Reputation points

2024-04-26T20:25:42.94+00:00

Thank you for your reply!

For example, the strings that can be entered in a column are "Product A, Product B, Product C" and other strings cannot be entered. The column type is text. I'm not sure about the format, but is it compatible if it's a formula that can be used in Excel?

2 answers

Your answer

Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff

2024-04-26T01:53:38.42+00:00

Hi @R N ,

Certainly! In SharePoint, you can use column validation to ensure that input adheres to specific rules. To better help you with your problem, perhaps you could tell me the exact type of column you have and what standard format you wish to implement.
R N 0 Reputation points

2024-04-26T20:25:42.94+00:00

Thank you for your reply!

For example, the strings that can be entered in a column are "Product A, Product B, Product C" and other strings cannot be entered. The column type is text. I'm not sure about the format, but is it compatible if it's a formula that can be used in Excel?

Answer 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

Answer 2

Xyza Xue_MSFT 30,241 Microsoft External Staff

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.

Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff

2024-04-30T05:20:14.13+00:00

Hi @R N ,

How's going today? Do you have further concerns regarding this issue? Please feel free to talk with us if you have other questions. If the above info is helpful to this question, you can click "Accept Answer". Have a nice day!

Share via

About SharePoint column validation

2 answers

Your answer