Help

Isssue with Switch formula for simple yes/no question

Topic Labels: Formulas
766 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeremiah_Norman
5 - Automation Enthusiast
5 - Automation Enthusiast

AirTable Communityc,

I am trying to find a simple way to score a “yes/no” question. I need to say that a yes answer is equal to a “1” and a “no” answer is equal to a “0”

I was using the switch formula but I cannot formulate it correctly. I also tried an “IF” formula without success. Thoughts? Here is my formula:

SWITCH({Aircraft - Is all equipment secured appropriately in the main cabin and the aft compartment?},
yes, ‘1’,
no, ‘0’,
‘0’
)

Thanks in advance!

3 Replies 3

A SWITCH is overkill in this situation. An IF statement will work, but it needs to be structured correctly.

When you have a text string, like the word yes put it in straight quotes. When you want a number like 1 or 0, do not use quotes.

IF(
  {Aircraft - Is all equipment secured appropriately in the main cabin and the aft compartment?} = "yes", 
  1, 
  0
)
Jeremiah_Norman
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks so much for your help. I am still unable to get the correct result but it did confirm the structure.

image

Do you see what I am doing wrong? I get the default = 0 for all the yes answers. The question is a single select question.

I figured it out. Spelling was an issue - must match the spelling exactly. Thanks so much for all your help.