To minimise duplication of data across my table I’ve converted a large number of Single Line Text fields to Lookup fields linking from a central sheet. Unfortunately the main use case for this data was access via URL parameter filterbyformula method ...
Thanks for the help.
I tried it but I couldn’t get it to work
To be clear (in case I’m doing something obvious wrong which I think I must be) here is a simplified example of ‘master table’:
Here is a simplified example of ‘table’ that links to the m...
