Custom formatting advice

Occasional Visitor

Good Morning.

 

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?

await

1 Reply

@Adamsibilski 

Try this custom number format:

 

[=1]"Yes";[=2]"No";"N/A"

 

If the user enters anything else than 1 or 2, the cell will display N/A.