Mandatory text to activate checkbox

edited 12/09/19 in Formulas and Functions

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:


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!