Need help on this formula

Options

This formula is not working for me:

=COUNTIFS({Status1}, "Complete", {Organization1}, "HR", {Quarter and Year}, "Q1 / 2024" && "Q2 / 2024")

Thanks

Answers

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭
    edited 06/21/24
    Options

    I think you may be missing an OR function, assuming that you want to count if the Quarter and Year is either Q1 / 2024 or Q2 / 2024?

    =COUNTIFS({Status1}, "Complete", {Organization1}, "HR", {Quarter and Year}, OR(@cell = "Q1 / 2024", @cell = "Q2 / 2024"))

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!