We have made updates to the
FLOOKUP LRM function. Below is the new list of modes currently available:
- Return the best match plus similarity.
- Return the best match plus row number.
- Return all matches for each item.
There has also been a significant change to Google's function timeout policy:
Before December 2020, those who were on Consumer accounts (e.g. @gmail or @googlemail accounts) could run our "Long Run Mode" functions for 6 minutes, while those on Workspace accounts could run those functions for 30 minutes.
However, since the beginning of 2021, all account types are now limited to running "Long Run Mode" functions for a maximum of 6 minutes.
As a result of this change, we have updated Flookup (Build 731) to ensure that all affected functions continue running smoothly.
We apologise for any inconveniences caused.