Formula Help

Kimberly Starasinich

Hi -

I am trying to create a formula that shows the conditions of:

Tasks due within the next 14 days that are not equal to the status of "Complete" or "not Required"

I am looking to do this on as a summary total on the project sheet.

Thank you for the help!

Paul Newcome

Give this a try:

=COUNTIFS(Finish:Finish, @cell<= TODAY(14), Status:Status, AND(@cell <> "Complete", @cell <> "Not Required"))

Dakota Haeffner

Hi Kimberly,

Could we have a screenshot or some column names?

Kimberly Starasinich

Paul Newcome

Give this a try:

=COUNTIFS(Finish:Finish, @cell<= TODAY(14), Status:Status, AND(@cell <> "Complete", @cell <> "Not Required"))

Kimberly Starasinich

This worked perfectly, thank you so much for the help!

Paul Newcome

Happy to help. 👍️