COUNTIF and...

Jessica Griffin

=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7)

I have this working, however how do I add Only if the Status column from origin sheet is not complete?

I've tried variations around this...

=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Tasks Range 1 - Status}, <>Complete)

Bassam Khalil

@Jessica Griffin 

Could you please share me as an admin on a sample copy of your sheet (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Bassam Khalil

Hi @Jessica Griffin

Hope you are fine, try to use "COUNTIFS" function it will help you to add another criteria

Jessica Griffin

These did not work either

=COUNTIFS({Template -Tasks Range 1 - Due Date}, <=TODAY(7), [Status]:[Status], <>Complete)

=COUNTIFS({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Tasks Range 1 - Status}, <>Complete)

Bassam Khalil

@Jessica Griffin

Try the following

=COUNTIFS({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Tasks Range 1 - Status}, <>"Complete")

Jessica Griffin

Still no luck, even after adding " " around Complete

Bassam Khalil

@Jessica Griffin 

Could you please share me as an admin on a sample copy of your sheet (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Jessica Griffin

Thank you for your help, I have created a copy of the workspace and shared it with you

Bassam Khalil

@Jessica Griffin

In which sheet the formula, please open conversation in that sheet

Jessica Griffin

Thank you @Bassam Khalil !!! You were a huge help!