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

Hi
You may use the following formula which will show you the percentage; however, you could use YES or Y as an alternative to the tick symbols. This is because if we change the column type to symbols then we cannot place a formula to display % values in it.
=IF(COUNTIF(CHILDREN(), "YES") > 0, COUNTIF(CHILDREN(), "YES") / 10 * 100, 0)
Also, you need to replace the number 10 (in the above formula) with the number of child rows of the given parent row to obtain the right percentage.
Hope this helps.
Best
Nasir (Zealvert)
Answers

Hi
You may use the following formula which will show you the percentage; however, you could use YES or Y as an alternative to the tick symbols. This is because if we change the column type to symbols then we cannot place a formula to display % values in it.
=IF(COUNTIF(CHILDREN(), "YES") > 0, COUNTIF(CHILDREN(), "YES") / 10 * 100, 0)
Also, you need to replace the number 10 (in the above formula) with the number of child rows of the given parent row to obtain the right percentage.
Hope this helps.
Best
Nasir (Zealvert)

Thanks so much this has worked perfectly
Help Article Resources
Categories
Check out the Formula Handbook template!