Move Row w/ Formulas

Options

I have 3 sheets that are being used in tandem:

Sheet 1     Registration Data

Sheet 2     Travel Requests

Sheet 3     Cancelled Registrations

Sheet #1 has a "registration status" field (dropdown). This field is being pulled into Sheet #2 by using an Index/Match formula. If the registration status (on sheet 1) changes to cancelled, I want the corresponding row on the travel request (Sheet #2) to move to sheet #3.

 I have a "move row" workflow set up on sheet #2 so that when the registration status changes to Cancelled, the row on sheet #2 is moved to sheet #3. But… it’s not working.

I'm assuming it's because the "registration status" field on sheet #2 is a formula and the trigger isn't necessarily coming from that sheet? Any help/advice?

Answers