-1

I have a problem changing a value in a Google sheet with this syntax:

=query(sheet!cell; "select column order by column " & if(sheet!column:column="value";"value1";"value2"))

If I try to only change the value, it works:

=query(sheet!column; "if column="value";"value1";"value2"")

If I try to take the value of the first sheet, it works:

=query(sheet!cell; "select column order by column")

How can I make a request QUERY SELECT and change the value of the request?

tehhowch
  • 9,645
  • 4
  • 24
  • 42
Talimbie
  • 1
  • 1

1 Answers1

1

You need a comma after the A and column R should be in your dataset if you want to use it to sort. Try:

=query(Inscriptions!A2:R109; "select N order by A, "&if(Inscriptions!N:N="oui";"R";"C"))

Chris Hick
  • 3,004
  • 1
  • 13
  • 15
  • Thanks Chris but it doesn't work. This make the request and result but the value changing doesn't work. – Talimbie Aug 06 '18 at 07:04