Automation Question

I have a sheet with one column showing "Approved (Y/N)". My automated notice is supposed to go out for approval when this is clicked "Y". All of the approvals were submitted and I hit Run on the whole sheet and it did, but it also sent out approvals for those with "N" or blank in the column.

Why did this happen and is there a way to retract or stop the automation on those that were not supposed to go out?

Thank you!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The problem is with the "Run Now" feature. It ignores any triggers and only evaluates conditions. If you did not have a condition of that cell being marked as "Y", then it will run for all rows.

    When not using "Run Now" and setting it up to trigger when the cell changes, you do not need the condition. Only the trigger of when the cell changes to "Y".