When setting a custom item settings filter in a lookup column, the formula that’s generated is incorrect.
This thinks its formula should be:
thisRow.[Source Doc].Lower() = Lower("Ops")
And that seems like it should work, but all the cells offer only Blanks as lookup options.
Retyping the formula manually as:
[Source Doc].Lower() = Lower("Ops")
(note that the
thisRow part is removed).
Causes it to work. I’m not totally sure why this is the case, but I’m pretty sure this is a bug.
Ready for @Federico_Stefanato ot tell me otherwise.