Using COUNTIFS to count a single name in a multi select box in a date range


Hi all,

This is my current formula, and it works except that if I have more than the name in the formula also checked in the multi select box it does not count it. How do I change this formula so it counts the name in the multi select box even if there are more than one name selected?

=IF(COUNTIFS(Date:Date, <=Date@row, [End Date]:[End Date], >=Date@row, [Test Staff Column]:[Test Staff Column], "Sample Name") > 1, 1, 0)



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!