"Move A Row" workflow automation triggered from VLookup cell

I have a Vlookup column that is showing a client status from a "master" grid. When I update the status on the master grid it will update the client status on the associated grid based on the Vlookup. That works fine. The problem is that both grids have an automated workflow that I am triggering that would move the applicable row based on the client status going to "cancelled". "Move a Row" can't be run on a delayed or daily basis, only upon triggering. With that instant trigger, the associated grid is then finding "#No Match", which makes sense. But even though in the workflow automation rules I can trigger based on a status of "#No Match" that doesn't actually trigger the moving of the row. The end goal is to move a cancelled client off our active grids that we work from. Any help is appreciated.

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!