#ERROR! when using ENCODE_URL_COMPONENT() on lookup?

Getting and #ERROR! when using ENCODE_URL_COMPONENT() on a lookup field of a text field. Can the formula be used on lookups?

Hmmm… good question (I guess).

I hate it when support people ask me “Why would you want to do that?”, and yet – here’s a good example of why someone might ask this question.

I’m sure you have a good reason, but I would love to hear it anyway - just curious.

As far as a lookup function is concerned, whatever is in the string is what it will attempt to match on. If the contents of that field is also URL encoded, I suppose it should work as I can’t imagine why Airtable would sanitize lookups in any way.