VLOOKUP with reference to another sheet fails randomly, empty columns (and filter issue)
I have a sheet with a few cells that uses vlookup to another sheet. At random times, the vlookup doesn't fail per se, it just updates the cell values to empty/blank. If I refresh the page, the values will reappear. But having to refresh the page every time this happens is very annoying.
On top of that, I have a filter based on this column, even after refreshing and the values are back, I need to disable the filter and re-enable it in order for the rows to be properly filtered.
The only solution I thought to resolve this, was to create a "local" copy in a separate column. But I can't create a workflow to copy another cell value, and it doesn't appear to also have a trigger to "not blank".
Any thoughts on how to resolve this? Why can't the workflows take a formula in each field (i.e. conditional to control when it is triggered, formula-based value to assign to the cell, etc.)
Help Article Resources
Check out the Formula Handbook template!