Sign in to join the conversation:
I am trying to count anything that is a past due task, but not counting items that are closed. What is the best formula to use?
My current formula:
=COUNTIF(Due:Due, <TODAY(1))
BUT this is counting all items that are due past TODAY. Any pointers?
=COUNTIFS(Due:Due, <TODAY(1), Status:Status, <>"Complete")
That is assuming your status column is labeled Status and its not a checkbox column. If it is a checkbox column, try
=COUNTIFS(Due:Due, <TODAY(1), Status:Status, 0)
Mike-
It is not supposed to count anything that is closed, lesson learned, or duplicate.
The current formula is:
=COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete")
This formula is counting those things, however, I need to count anything that is passed due and not closed, lesson learned or duplicate.
Thoughts?
Branden
See also these posts:
https://community.smartsheet.com/discussion/countifs-formula-help-0
https://community.smartsheet.com/discussion/count-anything-passed-due-excluding-certain-criteria
I am working on a sheet where we are tracking the percent complete within a column. The top percent complete formula is =AVG([Percent Complete]2, [Percent Complete]17). The formula in [Percent Complete]2 is =IF(Completed@row = "Completed", "100%", COUNTIF(Completed3:Completed16, "Completed") / 14) The purpose of the…
I am trying to turn off weekly backups, but it's not checked and it shows no history, yet I get backups every week. Is this a bug or there is another place I have to disable it? If it's the right place, why is there no history now?
I'm searching another sheet date column for the max date where two number columns (CID) are equal. It works fine, but if the list of dates contains a blank, I want the formula to return a blank instead of the max date it finds. =MAX(COLLECT({DAFD}, {CID}, @cell = [CID]@row))
