How to count on another sheet how many terminated employees per month?

Options

Hello,


I am trying to use the following formula in another sheet to count how many employees were terminated on the system per month:

=COUNTIFS({Status}, @cell = "terminated", Month@row, {Turnover per month 2021 Range 4}, Year@row, {Turnover per month 2021 Range 2})

What am I doing wrong?


Tags:

Answers

  • MCorbin
    MCorbin Overachievers Alumni
    Options

    Assuming the sheet you included in the screen shot is your raw data sheet, right?

    Try this:

    =COUNTIFS({Status}, Status@row, {Turnover Month}, [Turnover Month]@row, {Turnover Year}, [Turnover Year]@row)

    Note: When you're setting up a cross-sheet formula, you can use the "Sheet Reference Name" box to re-name your range, which makes it a LOT easier to troubleshoot your formula when you come back to it later:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!