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!