I have a question and a little note on how I resolved the issue I came across.
First the issue:
A “Y/N” column in my app looked like this:
I wanted it to change the display order from “N/Y” to “Y/N” so I put the following in “Data validity”:
So my issue is basically resolved but I have a couple of questions:
- Why does “N” come first even though this is called a “Y/N” column?
- The platform has a customization function that is a bit more intuitive than the “Data validity” expression I used (see “Yes/No display values” above). As is the case with a list put in the data validity spot, you can change the displayed values but the app will continue to write TRUE and FALSE to your sheet. However, unlike the data validity slot, the customization tool doesn’t let you adjust the order in which Y and N are displayed. Isn’t this a problem?