Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Cadet
2 months ago
Solved

How to Calculate Completion Percentage Using Multi-Select Boxes

I’m trying to create a formula that calculates the completion percentage based on a series of multi-select checkboxes. For example, if there are four checkboxes and three of them are selected, I’d...
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    2 months ago

    Try this

    var number NumberChoices = 4;

    var text value = ToText([My Multi select field]);


    var number NumberSelected =
    Count(
    Trim(Part($value,1,";"))<>"",
    Trim(Part($value,2,";"))<>"",
    Trim(Part($value,3,";"))<>"",
    Trim(Part($value,4,";"))<>"",
    Trim(Part($value,5,";"))<>"",
    Trim(Part($value,6,";"))<>"",
    Trim(Part($value,7,";"))<>"",
    Trim(Part($value,8,";"))<>"",
    Trim(Part($value,9,";"))<>"",
    Trim(Part($value,10,";"))<>"",
    Trim(Part($value,11,";"))<>"",
    Trim(Part($value,12,";"))<>"",
    Trim(Part($value,13,";"))<>"",
    Trim(Part($value,14,";"))<>"",
    Trim(Part($value,15,";"))<>"",
    Trim(Part($value,16,";"))<>"",
    Trim(Part($value,17,";"))<>"",
    Trim(Part($value,18,";"))<>"",
    Trim(Part($value,19,";"))<>"",
    Trim(Part($value,20,";"))<>"");

    $NumberSelected / $NumberChoices

    You should be able to use this formula by just adjusting the formula variables at the top so it knows the number of choices and also it knows which field to act on. 

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 months ago

Try this

var number NumberChoices = 4;

var text value = ToText([My Multi select field]);


var number NumberSelected =
Count(
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
Trim(Part($value,4,";"))<>"",
Trim(Part($value,5,";"))<>"",
Trim(Part($value,6,";"))<>"",
Trim(Part($value,7,";"))<>"",
Trim(Part($value,8,";"))<>"",
Trim(Part($value,9,";"))<>"",
Trim(Part($value,10,";"))<>"",
Trim(Part($value,11,";"))<>"",
Trim(Part($value,12,";"))<>"",
Trim(Part($value,13,";"))<>"",
Trim(Part($value,14,";"))<>"",
Trim(Part($value,15,";"))<>"",
Trim(Part($value,16,";"))<>"",
Trim(Part($value,17,";"))<>"",
Trim(Part($value,18,";"))<>"",
Trim(Part($value,19,";"))<>"",
Trim(Part($value,20,";"))<>"");

$NumberSelected / $NumberChoices

You should be able to use this formula by just adjusting the formula variables at the top so it knows the number of choices and also it knows which field to act on. 

  • MeaganMcOlin's avatar
    MeaganMcOlin
    Qrew Cadet
    2 months ago

    Mark,

    You have once again saved the day!

    This worked. Thank you!
    - Meag