Force Comment Entry

Terrapin69

what code could I use, in a cell or range of cells, that would "force" a user to input a comment in a certain cell based on their selection in another cell?

I have attached an example from my sheet - I would like, if a user chooses a "3" in column "sub rating", they are forced to enter a comment in the "comments" cell.

 

Thanks

Andrée Starå

Hi,

There isn't a way to force them to fill in a cell, but here are a few suggestions for workarounds.

1. Conditional formatting to indicate that something needs to be filled in.
2. A formula in the cell that would show a message that they need to fill in the cell.
3. If they don't fill in the cell, we could send an alert or an update request to remind them.

Would any of those methods work/help?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Terrapin69

Thanks!  This would probably work:

1. A formula in the cell that would show a message that they need to fill in the cell.

what formula would I utilize?

Andrée Starå

Try something like this.

=IF([Sub Rating]@row = 3; "Please fill in the cell with reasoning for the rating")

The same version but with the below changes for your and others convenience.

=IF([Sub Rating]@row = 3, "Please fill in the cell with reasoning for the rating")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Terrapin69

terrific and thanks!

Andrée Starå

Excellent!

Happy to help!