Right now, the Smartsheet Automation Trigger allows multiple criteria but the default in the statement logic is only OR.
There is no option to replace OR with AND.
Can you please add this?
Thank you for your feedback! In the meantime, you can use a Condition Block to be your "and" statement.
For example, if you want the workflow to trigger when "Status" changes to "Closed", and that row is assigned to someone specific, then could set it up like so:
The Condition Block acts as an "and" statement and only allows the workflow to follow through if all the criteria are met. Will that work for you?
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now