Forum Discussion
SharePoint Forced Comments
Is there a way that when/if a person answers B, C, D, or C/D in one column that they are required to enter comments into the list column? But not when they answer A.
Yes, this is done with list validation. Go to your list settings and select Validation settings:
My columns are called Choice and Comment. Add the following formula:
=IF(OR(Choice="B",Choice="C",Choice="D"),IF(ISBLANK(Comment),FALSE,TRUE),TRUE)When A is selected it will save without needing a comment. And if B,C or D is selected and a comment is added it will save:
But this is the error when B,C or D are selected and no comment has been added.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
