# How to display Yes/No instead of True/False in Pie Chart for new rows?

**URL:** <https://community.glideapps.com/t/how-to-display-yes-no-instead-of-true-false-in-pie-chart-for-new-rows/3708>\
**Category:** Ask for Help\
**Created:** [January 17, 2020, 10:52pm UTC](https://community.glideapps.com/t/how-to-display-yes-no-instead-of-true-false-in-pie-chart-for-new-rows/3708 "2020-01-17T22:52:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![alee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alee/32/2713_2.png) [@alee](https://community.glideapps.com/u/alee)\
**Post date:** [January 17, 2020, 10:52pm UTC](https://community.glideapps.com/t/how-to-display-yes-no-instead-of-true-false-in-pie-chart-for-new-rows/3708/1 "2020-01-17T22:52:04Z")

</div>

I have a column of a checkbox. I can write a data validation on existing columns to display custom text for true or false as Yes or No.

But for new rows, the data validation does not apply. Is there a way for me to display Yes/No dynamically? Or another way to do a pie chart of Yes/No votes?

![tf](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/324083abbf3ee52fa9fc48116305a8167c030bfa.jpeg)

 ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/32c66e7211835d4051ac6aaa48f5aec5eae24224.jpeg)

---

<div class="post-metadata">

**Author:** ![tru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tru/32/2108_2.png) [@tru](https://community.glideapps.com/u/tru)\
**Post date:** [January 17, 2020, 10:54pm UTC](https://community.glideapps.com/t/how-to-display-yes-no-instead-of-true-false-in-pie-chart-for-new-rows/3708/2 "2020-01-17T22:54:57Z")

</div>

![Screen Shot 2020-01-17 at 2.54.00 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1e8c77f7f60b1e68b9868010ff5ec258ed15e0ba.png)

You can use an if then else column in the data editor :)! Go to Data \> Add Column

---

<div class="post-metadata">

**Author:** ![alee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alee/32/2713_2.png) [@alee](https://community.glideapps.com/u/alee)\
**Post date:** [January 18, 2020, 12:05am UTC](https://community.glideapps.com/t/how-to-display-yes-no-instead-of-true-false-in-pie-chart-for-new-rows/3708/3 "2020-01-18T00:05:07Z")

</div>

prefect! thanks so much!