Number& type of comms per target audience


Hi ! I am completely stuck. I have columns:

  1. Target audience (ie: managers, employees..)
  2. Channel (email, meeting ..)

I managed to calculate the number of meetings, but I have no clue how to get to number of meetings per targeted audience. Is this even the right direction?

=COUNTIFS({channel},Meeting,{Target audience},Managers)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!