I can't get a COUNITF formula to work
Options
Lindsay P.
✭✭✭
I'm new to formulas and haven't done a COUNTIFS formula before. I'm trying to count data from two columns of the same sheet where 1) the date is in the past and 2) a checkbox is selected. What am I doing wrong?
=COUNTIFS({Daily Screening MAIN - Sheet Range 1}, < TODAY()), ({Request to be Onsite}, =1)
Tags:
Best Answer
-
Hi @Lindsay P.
Looks like you have some extra parentheses. See if this works:
=COUNTIFS({Daily Screening MAIN - Sheet Range 1}, < TODAY(), {Request to be Onsite}, 1)
Answers
-
Hi @Lindsay P.
Looks like you have some extra parentheses. See if this works:
=COUNTIFS({Daily Screening MAIN - Sheet Range 1}, < TODAY(), {Request to be Onsite}, 1)
-
John, you sweetheart you. That worked. Thanks!
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!