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
Problem Smartsheet environments quickly become cluttered with inactive Sheets, Reports, and Dashboards that are no longer viewed or updated. This creates confusion for users and significant overhead for admins, especially in large or regulated environments. There is currently no native way to automatically identify, notify…
I am loving the capabilities in Global Updates under Control Center.However, there are some gaps I would really like addressed.Can we please create a Global Update option to do the following: Update a column formula not just a cell formula Update an automation Note: I know that I could create a new column and delete the…
Most customer's metadata houses their profile data, some from intake sheet and some either cell linked in or brought into metadata using formulas. Needs change after design and often the new data point needed comes from non-metadata templates, which can cause a blocker if methods used are those above. If it were possible…
