"IF" formula using dates and check boxes

I am looking to set up a count to see how many people are scheduled for an appointment verses how many have come in.

I have an appointment date column and a check box that is clicked when someone comes in. I want this to be a summary formula not a cell. Could someone help?

What I messed around with was =COUNTIF(Name:Name,AND(Date:Date>=TODAY(),Check:Check=0))

I also tried an =IF(AND(Date:Date>=TODAY(),Check:Check=0),Count(Name:Name))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!