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
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!
