COUNTIF and...

Jessica Griffin
Jessica Griffin ✭✭✭✭
edited 06/30/21 in Formulas and Functions

=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)

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    @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.

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!