Count Past Due Task and Exclude Status that is Complete
I am trying to count past due tasks but exclude any tasks that are past the End Date. Below is my current logic that is NOT working.
=COUNTIFS({P904 - Walkthrough Past Due}, AND(@cell < TODAY (), AND(@Cell <> "Complete" )))
Below is logic that is counting all items that are past the End Date
=COUNTIFS({P904 - Walkthrough Past Due}, <TODAY())
Below are the Sheet Fields
Answers
-
You don't the second AND
Edit to add: if that does not work, I would create a checkbox column that tests your AND statement, and then use that column as the second COUNTIFS criteria.
-
=COUNTIFS( {P904 - Walkthrough Past Due}, < TODAY(), Status:Status, <> "Complete"
...
-
Attempted
=COUNTIFS({P904 - Walkthrough Past Due}, < TODAY(), Status:Status, <> "Complete")
Continue to get #UNPARSEABLE.
-
Is "Status:Status" supposed to be a {Cross Sheet Reference}?
-
Paul…Statu:Status is the column in the reference sheet P904 - Walkthrough Past Due.
-
If it is a reference to a sheet that the formula is not housed on, you need to create another {Cross Sheet Reference} the same way you did for the first range.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives