finding items past due

This is a formula to find out how many tasks Jane Doe hasn't marked complete in the last 7 days. It's not producing the correct number when I run it by a filter on the original dataset. Any insights on how to make it more simplified?

COUNTIFS({Project List Range 3}, FIND("Jane Doe", @cell) > 0, {Project List Range 4}, <>"Complete", {Project List Range 2}, <=TODAY(7), {Project List Range 2}, <TODAY())

Find more posts tagged with

Formulas

Comments

Mike Wilday

I don't have access to the data but it seems like you might be trying to limit the data by a greater than and a less than, but I am seeing two less thans. <=Today(7) would also include <Today() Did you mean >Today()?

Paul Newcome

That was also my first thought.

Mike Wilday

Did this solution work for you?

Sign in to join the conversation!

Quick Links

Trending discussions

Attaching a Message Sent to Vendor Acknowledging Contract
I've set up a Smartsheet that sends an approval request to a vendor to accept the terms of employment (outlined in a PDF generated with information from the sheet). They are not required to sign the document, just click Accept or Reject. While the contract (PDF) is attached to the row, and while I would have a date in the…
Netdays Formula
I am wanting to calculate Netdays but only if there is data in 'Corrective Action 1' I am currently using this formula: =IF(ISBLANK([Date Action 1 Complete]@row ), NETDAYS([Date of Event]@row , TODAY()), NETDAYS([Date of Event]@row , [Date Action 1 Complete]@row )) How do I adjust it to only pull a date when Corrective…
Re-write a formula to make it Column Formula compatible
I have Concept phase projects that can result in multiple Phase 1 projects being generated from one Concept Review. I want to calculate the time in the Concept Phase for the first project from that Concept (the Approved Gate 0 UID), but mark it N/A for any subsequent references to that UID. I figured out the formula below…