CODEWITHSUNDEEP
google-sheets
Small Atom
Small Atom

Reputation: 164

Copy Row To Another Sheet Based On Cell Value In Google Sheet

I'm Trying it:

 =FILTER('Orginal'!A:D, 'Orginal'!D:D="Complete")

Screens:

enter image description here

enter image description here

And i have Error. "formula analysis error"

enter image description here

What im doing wrong?

Upvotes: 1

Views: 2924

Answers (2)

nabais
nabais

Reputation: 2037

You are having a syntax error here:

enter image description here

Please use the following formula:

=FILTER('Orginal'!A2:D, 'Orginal'!D2:D="Complete")

enter image description here

update after finding solution

It turns out the solution had to do with the spreadsheet location.

The location of the spreadsheet can determine if the formulas have either a comma or a semicolon, as well as the format of the dates. To change your location of the spreadsheet, you can do it in:

file => spreadsheet settings => locale and change the locale there.

Upvotes: 1

Small Atom
Small Atom

Reputation: 164

Yeah bad screen.. but i found it... it was problem with this:

It shoud be :

=FILTER(Orginal!A:D;Orginal!D:D="Complete")

i changed "," to ";"

Upvotes: 1

Related Questions