Turning symbols into a percentage

I have a parent row where I would like to show the % of ticked answers for all the children rows . I can see that the tick is formatted as 'YES' but i can not work out the formula to change the yes into a number to get the %?

Best Answer


  • Laura_Murphy
    Laura_Murphy ✭✭✭✭

    Thanks so much this has worked perfectly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!