Sep 24 2023 11:18 AM
I would like to require a text field "Resolved notes" to be used when my choice field "status" changes to resolved.
Is this possible?
Sep 24 2023 11:39 PM
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:
=IF([Status] = "Resolved", NOT(ISBLANK([Resolved notes])), TRUE)
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.