Formula not working

Options

Hi

The following formula in my summary sheet is giving 6 as the result, which is incorrect. The correct number is 87.

=COUNTIF({Record ready}, <>"Yes")

When I create a filter in the source sheet, it is giving the correct result that is 87 records.

Any clues please?

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 09/15/21
    Options

    Hi @Nasir@EBC

    Hope you are fine, please try the following formula:

    =COUNT(COLLECT({Record ready}, {Record ready}, @cell <> "YES"))
    

    Or The Following Formula

    =COUNTIFS({Record ready}, @cell <> "YES")
    


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

  • Nasir@EBC
    Nasir@EBC ✭✭✭
    Options

    Hi Bassam

    Unfortunately it did not work.

    I'm pretty sure there will be some way out!

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Nasir@EBC

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 09/16/21
    Options

    @Nasir@EBC

    Am sure that the 2 formula is 100% working because i test it but i think you need to rectify the reference if you copy and paste it.

    if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.


    My Email for sharing : Bassam.k@mobilproject.it

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

  • Nasir@EBC
    Nasir@EBC ✭✭✭
    Options

    Hello Bassam

    Thanks for the support!

    I have just shared both the sheets with you with Edit rights.

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 09/17/21
    Options

    I tried to login but no access

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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!