We currently have an automation that changes the status of a parent item to “Done” if all sub-items have the status of “Done”:
When all subitems of an item have the subitem Status of Done, change the item’s Status to Done
We have introduced a new “Skipped” status to our workflow, to indicate when a task is not completed for whatever reason, but the workflow can still continue/this task is considered closed.
We would like to update the automation to consider this new status as follows:
When all subitems of an item have the subitem Status of either Done and/or Skipped, change the item’s Status to Done
We can’t do this with the current structure/options in place for automations (as confirmed with support). The recommended workaround is to change our status column to a dropdown column type, but this is not ideal for us for several reasons, including the fact that Monday.com is largely set up to function based on status labels.
Please add the functionality to use “and/or” fields/filters in automations.