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
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!