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 trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
Desired result is to pull the Initiative Name where the Days to Due Date is the least (so, due the soonest); then to make an index for the Top 10 Initiatives Due Soonest Currently using this formula: =INDEX(COLLECT({Project Master - Initiative}, {Project Master - Days to Due}, MIN({Project Master - Days to Due})), 1) This…
