Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Cadet
6 days 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
    4 days 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
4 days 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
4 days ago

Mark,

You have once again saved the day!

This worked. Thank you!
- Meag