I have come across a problem with custom formatting.
I have created checklists to use in our workplace. questions are simply answered with yes/no or N/A using drop down menus. feedback is to change it, so when you type "1" it returns yes, "2" would return NO and "3" would return N/A ( or different word if needed).
I have used custom cell format to achieve yes or no with : [=1]"Yes";[=2]"No"; unfortunately, it does not work when I try to add third option. is this only allowed for two options? or I am doing something wrong?