Counting Columns

Options
This discussion was created from comments split from: Партнёр в сообществе.

Answers

  • Roman Dianov
    Options

    Good day. I ask for your help. Every number in the calendar is counted by employees per day, night, swing. Help me find a formula so that the columns contain a score of the categories of each employee. thank.

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Roman Dianov

    You can use a COUNTIFS formula to count how many times each employee appears with each category/column.

    A COUNTIFS works like this:

    =COUNTIFS([Column 1]:[Column 1], "Criteria 1", [Column 2]:[Column 2], "Criteria 2"...etc


    So for your first person and column, try something this:

    =COUNTIFS([категория]:[категория], "D2", [пн 22]:[пн 22], <> "")

    <> "" means that the cell is Not Blank.


    You will need to update each formula to look into a different column as the second criteria. So the next row would be:

    =COUNTIFS([категория]:[категория], "D2", [вт 23-]:[вт 23-], <> "")

    Or whatever the name of that column is. Does that make sense?


    As an alternative, you may want to create a Report (see here) of this sheet instead. Then you can Sort the Report by the people in the категория column, Grouping it by this column (see here), and doing a COUNT as a Summary for each other columns. Would this work for you instead?

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!