Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Countif Tasks are completed late?
Hey There~
I'm trying to count how many of my tasks are being completed late and I'm struggling to do this.
Here's what I got:
Here is the formula:
=COUNTIF([Completion Dates]:[Completion Dates], >[Due Dates]:[Due Dates])
This returns zero but I want it to return three. However, =COUNTIF([Completion Dates]1, >[Due Dates]1) returns one.
I've tried variations of @cell but still no dice.
#SOS
Comments
-
Hey Andrew,
That's true, but I have a pretty large sheet and I'm trying to reduce the number of assisting columns.
Thanks~
-
Alternative solution:
Create a checkbox column where to identify if a row's Completion Date > Due Date. Then, count that column to get your result.
=IF([Completion Dates]1 > [Due Dates]1, 1)
=COUNTIF([Past Due]:[Past Due], 1)
-
Johnny,
I'm pretty sure this (an additional column) is not one you can avoid.
The COUNTIF or COUNTIFS functions allow ONE cell reference, not a matching one is another column of the same size.
There is no OFFSET function, so even trying to use the @cell reference for one column to the right, for example, won't work either. I (like you) tried various things with @cell and came up empty.
There is no way to "store" a value in the formula and use it later in the same formula.
All of the usual suspects are dead ends.At least for now.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives