Jun 07, 2023 06:41 AM
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?
Jun 07, 2023 07:20 AM
Hi @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
Jun 07, 2023 08:57 AM
The "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.