Count matching criteria in multiselect columns

Options

Hi all,

I'm struggling to find an answer to this question.

I have a set of criteria in a multiselect column (assigned training), then another set of criteria in another multiselect colum (completed training).

I'm trying to show the % completed by counting the number of completed training values (that match assigned values) and dividing this by the assigned training values (which I can use a COUNTM function for).

Any help would be appreciated

Answers

  • Stefan
    Stefan ✭✭✭✭✭✭
    edited 09/11/20
    Options

    Hi @Cale Hutchins,

    like this?

    =COUNTM([completed training]@row) / COUNTM([assigned training]@row)

    The cell with the formula needs to be formatted as %.

    Hope this helps

    Stefan

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!