Formula for COUNTIF

We have a form for tracking sick time. Employee must fill out the form on first day of sick. They have to fill out the same form again when they return to work. These are both tracked in the Status column (Sick and Returning).

We also have another column titled quarantined and the drop down options are yes and no. This info fills to one sheet. I would like to COUNT all "Yes" responses to quarantine that have not yet answered returning.

There will be multiple names on the sheet and most will have two entries as sick and returning. The only ones I would like to count are the people that have a sick entry and no returning entry yet AND have said yes to the quarantine question.

Is this possible?

Thank you

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!