I am trying to have the checkbox (Status) marked check when OPT2 has all of OPT1 values.
OPT1 is fixed value, while OPT2 is user's input.
What is wrong with my automation here? am I using the "has all of" operator incorrectly?
"HAS ALL OF" operator not working
+18Hi @geetee,
I would try the "when record matches condition" trigger. You might have to copy and paste all OPT 2 cells across all rows to activate the automation after it's turned on.
Hope that helps!
-Stephen
+29The "has all of" operator works best when you can hardcode the specific options from the dropdown. It doesn't work so well when you are using a dynamic condition because Airtable probably doesn't break down the options in the dynamic conditions as individual options.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.