Ability to exclude a single column from an Automation Trigger

We have an automation that triggers when any field is added or changed and sends updates. However, we have a field that calculates the aging of each line item. We would like to exclude this single field from the trigger. Currently, our only option is to select all of the columns you DO want to be included, but not ones to exclude.

Sign in to vote!

Find more posts tagged with

Automations

Idea Submitted

triggers

Comments

Andrée Starå

Hi @Melissa Bosi

I hope you're well and safe!

As a possible workaround, add a helper column that joins everything except that cell and then change it so that if that column changes, it triggers the workflow.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

A.J.

@Andrée Starå, I had the same idea of a helper column, but I also thought about using the sheet summary for the aging information as that wouldn't trigger the automation, either.

Andrée Starå

@A.J.

The problem with the aging on the Sheet Summary would be that it needs to be per row.

Melissa Bosi

I currently created an automation added all columns except the aging columns to the trigger criteria. It would just be more efficient to choose "Any field" except "XYZ field".

Quick Links

Trending ideas

Automations Tracker
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Preserve Original Filenames for Multi-Photo Uploads in Smartsheet Mobile App
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
Data Shuttle Notifications for any type of Error
We are recently starting to use the Smartsheet API and Data Shuttle for maintaining Dashboards. We have discovered that the Data Shuttle workflow will notify the owner when the process completely fails, however it will not send notifications wuth a partial failure indicated by the Yellow Caution sign. Since many of our…