"Change Cell" Automation Not Working

I have created an Automation that auto-assigns a technician based on names in another cell within the same sheet and it is not changing my cell values:

The Trigger is set for when a row is added (rows are typically added in bulk as a copy paste from an Excel File)

The "Audit Assigned to" Field is a single-select dropdown

Tags:

Best Answer

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

    The way your trigger is set up, it will only trigger if all of those values are present at the same time. I think you are going to want to enter one, then click on "Specify another change" and make sure that it is set to "or". List the next, then keep doing that until all values have been entered individually.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers