Share via

What is the correct syntax formula when attempting to make a text field mandatory?

GM 0 Reputation points
2024-10-29T19:07:08.5366667+00:00

Hello,

I'm attempting to setup List Validation to enforce a "Multiple lines of Text" (High Prioritization Selected - Explain Why) Column be required if the Prioritization within Value Stream Column is set to "High". If the Prioritization within Value Stream Column is set to "Medium" or Low" the High Prioritization Selected - Explain Why is no required.

Appreciate the assistance!

Microsoft 365 and Office SharePoint For business Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff
    2024-10-30T09:29:33.32+00:00

    Hi @GM ,

    Welcome to Q&A forum!

    Please go to List settings -> Validation settings -> Use following formula:

    =IF([Prioritization within Value Stream]="High",IF(ISBLANK([High Prioritization Selected - Explain Why]),FALSE,TRUE),TRUE)

    User's image

    And then the result:

    User's image

    Good day!

    If the answer is helpful, please click "Accept as 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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.