COUNTIF the values is lesser than today's date

Options

Hi Folks,

I would like to count the names with respective to dates in another column which is lesser than today's date.

I used the below formula:

=COUNTIFS([Projected CM1]:[Projected CM1], <=TODAY(), [CM1]:[CM1], "Flextronics Wuzhong CM")

But it doesn't give the right result, any leads please advise

Thanks!

Raj


Answers

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

    Hi @rajcanada 

    Hope you are fine, please try the following formula:

    =COUNTIFS([Projected CM1]:[Projected CM1], @cell <= TODAY(), [CM1]:[CM1],
    @cell = "Flextronics Wuzhong CM")
    

    the following screenshot shows the result:


    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"

  • RajKumar 28
    Options

    Hi Bassam Khalil,

    Is that we have to change the date format? It doesnt works for me.

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

    @rajcanada 

    No need to change the date format, but your date column must be date type.

    if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheet 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"

  • RajKumar 28
    Options

    Hi Bassam Khalil,

    Thanks for your help, now i have the column to date format & it works now.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!