Countifs check box is blank between dates
Samuel Dowdy Jr.
✭✭✭✭✭
=COUNTIFS({MASTER - Daily Report - Employee}, [Employee Name]@row, {MASTER - Daily Report - PM Checkbox}, 0, 1, {MASTER - Daily Report - Date} >= [Start Date]@row, {MASTER - Daily Report - Date} <= [End Date]@row)
Answers
-
@Samuel Dowdy Jr. I think you have an issue with commas and criteria pairs. Are you sure those yellow items are in the proper place?
... just my first glance ...
dm
-
im not sure of anything...
Im trying to count how many check boxes are not checked if the criteria is met, especially if its between the dates
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!