# Tracking total responses to yes/no questions

**URL:** https://community.glideapps.com/t/tracking-total-responses-to-yes-no-questions/14119
**Category:** Ask for Help
**Created:** [August 18, 2020, 1:09am UTC](https://community.glideapps.com/t/tracking-total-responses-to-yes-no-questions/14119 "2020-08-18T01:09:34Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Jarrett\_Schweim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarrett_schweim/32/3476_2.png) [@Jarrett\_Schweim](https://community.glideapps.com/u/Jarrett_Schweim)
#### Post date: [August 18, 2020, 1:09am UTC](https://community.glideapps.com/t/tracking-total-responses-to-yes-no-questions/14119/1 "2020-08-18T01:09:34Z")

</div>

In my app, I have a yes/no response in each section. It is all tracked in one column of data. How am I able to track the. Total “yes” and “no” answers?  
It is easy to add numbers up in a column and get total, but how do I do this with alpha columns?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 18, 2020, 1:11am UTC](https://community.glideapps.com/t/tracking-total-responses-to-yes-no-questions/14119/2 "2020-08-18T01:11:03Z")

</div>

You can do a relation to return all the Yes and make a rollup to count the number of Yes answers.

---

<div class="post-metadata">

### Author: ![Jarrett\_Schweim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarrett_schweim/32/3476_2.png) [@Jarrett\_Schweim](https://community.glideapps.com/u/Jarrett_Schweim)
#### Post date: [August 18, 2020, 1:15am UTC](https://community.glideapps.com/t/tracking-total-responses-to-yes-no-questions/14119/3 "2020-08-18T01:15:34Z")

</div>

Thank you. Excuse my lack of understanding, but what does that mean?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 18, 2020, 1:18am UTC](https://community.glideapps.com/t/tracking-total-responses-to-yes-no-questions/14119/4 "2020-08-18T01:18:01Z")

</div>

You can follow the steps below:

- Create a template column with the word “Yes”.

- Make a relation matching that template column with your answers column, return multiple matches.

- Create a rollup column, take value from the relation and set the calculation to count.

Follow the same process for “No”. I imagine it would be the same.

The other way to do this would be through a chart component, if you don’t mind a chart I think it would be easier.

---

<div class="post-metadata">

### Author: ![Jarrett\_Schweim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarrett_schweim/32/3476_2.png) [@Jarrett\_Schweim](https://community.glideapps.com/u/Jarrett_Schweim)
#### Post date: [August 18, 2020, 1:23am UTC](https://community.glideapps.com/t/tracking-total-responses-to-yes-no-questions/14119/5 "2020-08-18T01:23:30Z")

</div>

Thank you very much! Mission accomplished
