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
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
The current logic behind the "Last Activity" column in the True-Up is not useful for performing True-Up nor ongoing reviews of licensed seats. I need to know when someone last made a modification to any sheet regardless of the level assigned to the modified sheet. In my case I have a project manager who is an owner on…
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…
