Googlesheets Look for value in cell, not exact

[e0979d]

Which steps could I follow if I want to check for a value in a spreadsheet but it's not the exact content? per example: I'd be looking for "100" or "part-" and want to find a match for "part-2" in the search

 

[Supreme]

Hey @e0979d

Which steps could I follow if I want to check for a value in a spreadsheet but it's not the exact content? per example: I'd be looking for "100" or "part-" and want to find a match for "part-2" in the search

Does both the data values will be in the same cell and does they will be separated by any symbol or character?

 

[e0979d]

Hey @e0979d



Does both the data values will be in the same cell and does they will be separated by any symbol or character?

This is the more clear example:

I want to look for "2024-month-30", and the cell will have the following data: "2024-month-30.jpg"

 

[Supreme]

I am sorry to say that the contains filter type for cell value cannot be achievable with the LookupSpreadSheet action step.

 

[e0979d]

I am sorry to say that the contains filter type for cell value cannot be achievable with the LookupSpreadSheet action step.

I understand, but is there any step I can perform to achieve such result?

 

[Supreme]

I understand, but is there any step I can perform to achieve such result?

Can you please share your workflow once so that I can perform a small test on the workaround to get the specific row that contains the type?