Automation - Update Column Trigger Not Working for Multiple Cell Edits

I have an Automation that is triggers when a column is updated. However, this only works when one cell is changed at a time. When multiple cells in the column are deleted, or when dragging a value down to copy/fill the column, or when pasting a value into multiple cells, the trigger is not activated for any of the cells.

Note: you can test this in my shared “Construction Schedule” workbook. I’m using my own [% Done] column instead of the Progress column because I want the colors of the bars to match exactly the colors that I’ve chosen in the Color column (by making the progress 100% by default). When I enter 100% in my [% Done] column, the automation changes the color of the bar to Gray (because I want all of my completed tasks to be gray).

1 Like

This is a current limitation. We will be addressing this in a near-future iteration. I will be updating here as we have changes to report.

1 Like