Can I copy rows based on a formula updating?
Hi All -
I'm working on new process, and have everything working except one small (seemingly) problem. I have two sheets that talk to each other, and they work fine. In Sheet 1, I have a status field (drop down), and in Sheet 2 there is corresponding Status field. When Sheet 1's Status field gets changed, Sheet 2's Status field is updated via a VLOOKUP. All of that works completely fine.
What I am trying to do though, and is not working, is use an Automated Trigger to Copy a Row from Sheet 2 to Sheet 3 based on the Status in Sheet 2 changing to a certain value.
So, an example would be - when Sheet 2's Status field = "Complete", Copy the Row to Sheet 3. It's not working, and the only thing I can think is it's not firing because the Status in Sheet 2 is being updated via a formula (VLOOKUP) and the Automated Workflow doesn't recognize that.
Any thoughts / help would be great appreciated. I'm pretty stumped on alternative options.
Help Article Resources
Check out the Formula Handbook template!