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

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?


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

prefect! thanks so much!