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.
+35The 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"
)
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! <3 Thank you so much! I was getting SO frustrated not understanding.
+35You are my hero! <3 Thank you so much! I was getting SO frustrated not understanding.
You’re welcome! Glad to be your superhero this morning! :man_superhero:
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.