Autopopulate If Empty

Topic Labels: Formulas
997 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hey AirTable community!

I want to to autopopulate a field (specifically a single select field, but this query could apply more broadly to other field types as well) with “No” if “Yes” is not selected.

I have a massive data set with “Yes” sprinkled throughout that field type. I know I could filter to show blanks and manually select “No” and click+drag, but I will be continually adding new records and I want the preset for this field to be “No.”

Any solutions??

1 Reply 1

Hi @Jesse_Gibson - the single select field type doesn’t have a default so you can’t solve it in this way. You need a formula, but a field can’t be a formula and something else at the same time. The workaround is to create a new field (a formula) that can show “yes” or “no” based on your single select field:

Screenshot 2019-06-26 at 22.01.12.png

The formula is:

IF({Yes/No} = 'Yes', 'Yes', 'No')

Does this work for your scenario?