Forum Discussion

em_amdahl's avatar
em_amdahl
Copper Contributor
Sep 24, 2023

Can I require a text field based on a choice selection in SharePoint online list?

I would like to require a text field "Resolved notes" to be used when my choice field "status" changes to resolved. 

 

Is this possible?

Lists
SharePoint Online
  • Lalit Mohan's avatar
    Lalit Mohan
    Iron Contributor
    Sep 25, 2023

    Hi em_amdahl 

    Yes, it is possible to require a text field based on a choice selection in SharePoint Online list. To do this, you can use list validation.

    To create a list validation rule:

    1. Go to the list where you want to create the rule.
    2. Click on List settings.
    3. Under General settings, click on Validation settings.
    4. In the Validation formula field, enter the following formula:
    =IF([Status] = "Resolved", NOT(ISBLANK([Resolved notes])), TRUE)
    1. In the Validation error message field, enter the message you want to display to users if they try to save the item without filling in the Resolved notes field.
    2. Click on OK to save the rule.

    Now, when a user changes the Status field to Resolved, they will be required to enter a value in the Resolved notes field before they can save the item.

    Best answer:

    Yes, you can require a text field based on a choice selection in SharePoint Online list using list validation. To do this, create a list validation rule with the following formula:

    =IF([Status] = "Resolved", NOT(ISBLANK([Resolved notes])), TRUE)

    This formula will require users to enter a value in the Resolved notes field if the Status field is set to Resolved.

Resources