What’s faster, running the query in Google sheets, or a virtual column?
It depends on the expression.
It should be Google Sheets, but we do some pretty good optimizations in our backend so there will be some cases where a virtual column actually runs faster.
@Grant_Stead with complex queries, we generally prefer to use the gSheet rather than the VC, as complex query expressions in a VC are quite expensive and results in long sync times.
Was just wondering this, TY!