Can Sheet Filter reads cell that contains a certain text?

If I have two cells that contain the word “Food” inside. One is just “Food”, and one is “Food for thought”. If I write “Food” in the Value box of the Filter section, It only detects one cell.


Is there a way to detect both of them? Thanks!


Hey @rexnguyen, unfortunately the filter is looking for an exact value right now. There’s an easy workaround for this though: Just add an If node after your sheets node that will filter out non-fitting values. See my example below

Hope that helps!


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.