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?
Sign in to see the current vote count, add your own vote, or leave a comment.
Hi @Erin Horiuchi Green
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
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid
