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?