My 'And' formula is not working


I would like that the check box in a column is checked when the task is a child and also when the % complete column is 100%.

My formula:

=IF(AND([% Complete]@row = 100, Level@row = 0), 1, 0)

This doesn't update the checkbox even when both conditions are true. I tried saving and refreshing. Strangely, this formula in another column works

=IF(AND([% Complete]@row <> 0, Level@row = 0), 1, 0)

The only difference is the '= 100' vs '<> 0'

The % complete column is a text/number column, and the % button is selected.

It is also referenced in the project settings dependencies box.

Thanks for any support.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!