Mandatory text to activate checkbox

brenttopa

I have a "Notes" column that requires text before the checkbox under "Req Attn" will be checked, kicking off conditional formatting in other columns.

 

I found this thread and tried to implement the suggested solution:

https://community.smartsheet.com/discussion/formula-help-if-cell-blank-checkmark-cannot-be-checked

 

I created a third column, "WrongOrder1", and then this formula:

 

=IF(AND(ISBLANK(Notes3), [Req Attn]3 = 1), 1, 0)

 

However, entering text under "Notes" does not check the box.  I can check the box and the corresponding checkbox will become checked, if that helps.

Mike Wilday

It sounds like you may want to use NOT(Isblank(Notes3)),

=IF(AND(NOT(ISBLANK(Notes3)), [Req Attn]3 = 1), 1, 0)