0

In google sheet, if you use formulas in one cell, it seems it cannot be found by filtering with content. I think the reason is that google sheet don't think it is a text cell. Then how can I search or filter based on the content of the formula. For example, I have several cells which value is:

=IMAGE("https://-----.googleusercontent.com/-----------------")

I cannot search it by string or text like "googleusercontent". How can I filter or search this cell? Thank you very much.

yuxuan
  • 417
  • 5
  • 16
  • 2
    Beware of pasting unknown content into your spreadsheet – Cooper Dec 10 '21 at 17:26
  • How about [getFormula()](https://developers.google.com/apps-script/reference/spreadsheet/range#getformula)? – Cooper Dec 10 '21 at 17:30
  • @Cooper Thank you. I agree. I will update the content in my post. – yuxuan Dec 11 '21 at 20:00
  • If I understand it right. What you suggest is to add a new column with "getFormula()". Then filter with new column. Am I right? However, it is not suitable if the sheet cannot be edited. – yuxuan Dec 11 '21 at 20:06
  • What I suggest is that you research getFormula and figure out what you need to do on your own. – Cooper Dec 11 '21 at 20:50

1 Answers1

0

You can go to the Find and Replace dialog (press Ctrl+H) and check Also search within Formulas:

enter image description here

You will see the cells with formulas unwrap as this option is checked.

CMB
  • 4,950
  • 1
  • 4
  • 16