Logic formula for checkbox


I am trying to get a box checked if a completion date has been entered OR a status has been marked complete.

Formula I have is

=IF (Status3 = "Complete") OR NOT(ISBLANK([Real Completion Date]3)),1

What am I doing wrong here?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!