CountIF formula Help

Options

Hi everyone and anyone!


I have this formula below but I need to add progress stage to it. What I thought would work is coming back with unparsable. Can anyone lend a hand?

=COUNTIFS({HR Go Live or Event Date}, >=TODAY(0), {HR Go Live or Event Date}, <=TODAY(90))

Formula I need to work

=COUNTIFS({HR Go Live or Event Date}, >=TODAY(0), {HR Go Live or Event Date}, <=TODAY(90),({HR Projects - Project Stage IP} "In Progress", "Waiting to start")


I'm sure it is a simple fix, I'm just not seeing it. Thanks for any help!

Answers

  • Ramzi K
    Ramzi K ✭✭✭✭✭
    Options

    @Krista Coffman

    It appears you have an extra parenthesis, a missing comma, and an extra condition in your statement.


    Try this instead:

    =COUNTIFS({HR Go Live or Event Date}, >=TODAY(0), {HR Go Live or Event Date}, <=TODAY(90), {HR Projects - Project Stage IP}, "In Progress")

    If you need to count where it's either In Progress or "Waiting to start" then add two statement together:

    =COUNTIFS({HR Go Live or Event Date}, >=TODAY(0), {HR Go Live or Event Date}, <=TODAY(90), {HR Projects - Project Stage IP}, "In Progress") + =COUNTIFS({HR Go Live or Event Date}, >=TODAY(0), {HR Go Live or Event Date}, <=TODAY(90), {HR Projects - Project Stage IP}, "Waiting to Start")

    I hope that helps.

    Ramzi

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

  • Krista Coffman
    Krista Coffman ✭✭✭✭
    Options

    I can't get the OR statement to function for the second part of the formula. I get back unparsable.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!