Rolling 2 week task count

edited 12/09/19 in Formulas and Functions



I am trying to do a cross sheet formula that counts the number of tasks that are not complete and have a due date in the next 14 days for a specific department. I hope I am close but it is coming back as unparseable.

Could someone please review and tell me where my mistake is? Please find my formula below.

=COUNTIFS({sheet reference}, “Department”, {sheet reference date column}, >Today+14, {sheet reference status column}, “”, {sheet reference status column}, “doing”)

Thank you,


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!