Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

If "QTY Used in Part" Equals 4, 550, or 1000 Then "correct" if not then "incorrect"

Topic Labels: Formulas
141 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Not sure how to properly write this out in a formula.

I’ve got it working with this one formula: IF({QTY Used in Part}=1000,“ :white_check_mark: Good :white_check_mark: ”,“ :red_circle: Incorrect :red_circle: ”)

I’ve tried just using a bunch of IF statements, I’ve tried to make AND/OR work to no avail (probably not doing it right), I’ve read about Switch but am unsure of how to make it work for my needs - I have no idea where to go from here.

Please help.

3 Replies 3

The forum software won’t let me show you this with emojis, but here’s the structure of the formula:

SWITCH(
{QTY Used in Part},
4,"Good",
550,"Good",
1000,"Good",
"Incorrect"
)

You are my hero! ❤️ Thank you so much! I was getting SO frustrated not understanding.

You’re welcome! Glad to be your superhero this morning! :man_superhero: