Googlesheets Look for value in cell, not exact
Status: Closed · Asked by e0979d on · 0 views
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
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?
Hey @e0979dDoes 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"
I am sorry to say that the contains filter type for cell value cannot be achievable with the LookupSpreadSheet action step.
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?
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?