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
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
