Hi, Can someone help me figure this out. I'm trying to

Hi can someone please help me figure this formula out? I'm trying to get the number of open tasks. The task is considered open if 1, the check box is blank and the Date Completed is open and if a task has not yet been assigned to someone.


=IF(OR(ISBLANK("Done"), ISBLANK([Assigned To]), [Date Completed])1) = "Checkbox is blank"),1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!