It would all be easier with a ContainsAll function!
Glad to help. I’d love to see your progress with this later on.
I was playing with something similar, thought I’d paste the full recipes text in a column, then use the natural language package to autocategorize it. Wasn’t sure on how to do the search, now your idea of ‘Maker’ helped me too!
Btw, I’d like to see some dev explan why this worked:
As the color shows, the parser identifies CurrentValue as a row of Food item DB inside the Filter scope, but that way the formula makes no sense.
It only makes sense if CurrentValue was the current category being evaluated in FormulaMap. Given that it actually worked, I can only infer that that’s what happening, although the colors show otherwise.
This only adds to the confusion regarding scope that some members have pointed out.
Thanks! I’m only inspired by you and others before me 