Automation Not Responding to VLOOKUP

Dakota Haeffner

Hello Everyone,

I have some data coming in from DataShuttle every morning to update status on pieces of work identified by 'OMNI #'s' (ex. OMNI123456). I have a formula in my sheet that looks at the OMNI number we put in then goes to the import from DataShuttle to find what the status was updated to that morning. Here is the column formula: =IFERROR(VLOOKUP([SN OMNI#]@row, {OMNI (Open)}, 8, false), VLOOKUP([SN OMNI#]@row, {OMNI (Closed)}, 7, false)) The formula works the way it was intended to.

I'd like a few automations to run on that status column to move the row to another sheet if the row is "Closed" or "Canceled," but for some reason my automations don't seem to be doing anything when I make the trigger around the SN Status column.

below are some screenshots...

To be clear, the automation is not sending out any email for approval or anything when the line is marked as closed.

Any guidence is appreciated!

Paul Newcome

Automations cannot be triggered by data coming from another sheet (cell links/cross sheet references in formulas). You would need to set the trigger to be time based and then use the column containing the cross sheet formula as a condition.

Ami Veltrie

Check the configuration of the "Request an Approval" step by clicking the three dots (kebab) menu. Make sure the values are as expected.

Send a screen shot if you still have questions.

Dakota Haeffner

Everything looks correct in here. @Ami Veltrie

Paul Newcome

Automations cannot be triggered by data coming from another sheet (cell links/cross sheet references in formulas). You would need to set the trigger to be time based and then use the column containing the cross sheet formula as a condition.

Ami Veltrie

@Paul Newcome you're the best!

Paul Newcome

Happy to help. 👍️

Dakota Haeffner

@Paul Newcome GOAT! Thanks Paul!