COUNTIF and...

Jessica Griffin · 06/30/21

=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 · 07/01/21

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 · 06/30/21

Hi @Jessica Griffin

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

Jessica Griffin · 06/30/21

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 · 06/30/21

@Jessica Griffin

Try the following

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

Jessica Griffin · 07/01/21

Still no luck, even after adding " " around Complete

Bassam Khalil · 07/01/21

@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 · 07/01/21

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

Bassam Khalil · 07/01/21

@Jessica Griffin

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

Jessica Griffin · 07/01/21

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

COUNTIF and...

Best Answer

Answers

Help Article Resources

Categories