Automations and Cell Linking
I've read in a few past threads that automations will not work with Cell Linking. For example, I have a column that uses VLOOKUP to pull a Status from another sheet that is imported via Data Shuttle on a daily basis. I wanted to have the rows moved to my completed sheet anytime the Status changes to Closed. It would seem that it doesn't recognize that it is closed.
Has anyone found a work around to this? I tried a helper column that displays whatever is in that cell as text but it doesn't seem to be working. Thanks!
Help Article Resources
Check out the Formula Handbook template!