Help

Single Select Menu and Formulas

3066 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Terry_Curry
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to the get single select menu dropdown integrated into a formula.

Essentially I want a 1/0 depending on whether it’s the option I want or not…

This is what I guessed but it’s not working

IF ({DROPDOWNMENU} = “the text I’ve got there”, ‘1’), '0’
IF ({DROPDOWNMENU} = “the text I’ve got there option 2”, ‘1’), '0’
IF ({DROPDOWNMENU} = “the text I’ve got there option 3”, ‘1’), ‘0’

The purpose of this is to be able to launch a specific ZAP based on the form choice a person selects.

Form question might be like "Do you like cats dogs or alligators?"
The zap could then use the formula above to send them an email based on their response when the formula box comes into view with a 1.

Maybe I’m approaching this wrong but advice is appreciated

3 Replies 3
Matt_Bush
Airtable Employee
Airtable Employee

Almost there, you just need to move the clothing parenthesis ) over to the right:

IF ({DROPDOWNMENU} = "the text I've got there", '1', '0')

Note that it’s not necessary to wrap the 1 and 0 in quotation marks. If you don’t wrap them in quotation marks, they’ll be treated as numbers, and not text, so you can use numeric filters and summary functions on them:

IF ({DROPDOWNMENU} = "the text I've got there", 1, 0)

Yeah that fix of moving the parenthesis worked. That solved the box check issue so thank you.

Still playing around with the system and I’m wondering how to nest that one?

Ex. I’m working on now is returning the day of the week written out (“Wednesday”) from a weekday number 0-6

Matt_Bush
Airtable Employee
Airtable Employee

Please refer to our guide to Nested IF formulas: https://support.airtable.com/hc/en-us/articles/221564887-Nested-IF-formulas