Trouble with getting a SmartSheet Formula to Work for counting past due tasks by assigned.

So i've been trying to come up with a formula that will count all past due tasks by assigned user.


I was able to get a formula to show ALL tasks (due and not due) by assigned

[=COUNTIF({Project Tracker Range 1}, Who@row)]


I use the formula to shows ALL past due from ALL users:

[=COUNTIFS({Project Tracker Range 3}, <TODAY())]


However when it comes to the variable of past due by assigned it errors, #invalidoperation:

=COUNTIF(AND({Project Tracker Range 2} = Who@row, {Project Tracker Range 3} < TODAY()), < TODAY())


Any help would be much appreciated, spending too much time trying to figure this out.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!