What I'm trying to accomplish is a custom filter view:
If a cell in column F is not blank OR if a cell in column A has a certain
string then show the row. Otherwise hide the row from view. So I created a
new filter view and put Filter by condition / Custom formula is:
=OR(IF(FIND("x",INDEX(A:A))>0,TRUE),NOT(ISBLANK(F:F)))
This just doesn't work. If either IF(FIND("x",INDEX(A:A))>0,TRUE)
or NOT(ISBLANK(F:F)) is tested alone without the OR, it works as expected.
But if OR is used as in the example, it doesn't work. Is this a bug?
Also I couldn't figure out how to define a custom filter view's Range as
simply the whole F column. I have to put F1:F200 and then if more rows are
added, that is broken (not automatically growing).
Also I tried to call a function in my script from the "Custom formula is"
field, but it seems that that field doesn't support custom scripts. Is this
correct?
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
