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.

image

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

image

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!

2 Likes

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