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
-
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())
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!