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

DormanDave

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.

ChloeSmith

I might be wrong, but I think you could use a COUNTIFS function and combine the two phrases.

=COUNTIFS({Project Tracker Range 1}, Who@row, {Project Tracker Range 3}, <TODAY())

DormanDave

Thanks! @ChloeSmith , that worked! I tried that before, i think someone may have been moving columns on the reference sheet, as the reference column numbers changed.

Appreciate you!