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

Copper Contributor

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

 

Is this possible?

1 Reply

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.