Simple IF function not working


I have an issue with a simple IF formula. Here's the formula: =IF(Completion1 = "100%", "Closed", "Open") for Overall Progress Column.

It's not working. Even if the value is NOT equals to "100%", the value showing is the false one (Open). I don't know why it's not working.

A note: The logical expression (Completion column) I am evaluating counts the average of checkboxes marked across a row. Does this mean the IF column does not work in marked checkboxes?

Please let me know if you have alternatives or suggestions. Any ideas are much appreciated. Thanks so much!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!