Skip to content

How can we improve Proton Drive?

← Proton Drive

byrow function

I'd like to see a function like byrow which can be used to apply a lambda function to spcified rows (s. https://support.google.com/docs/answer/12570930?hl=en&sjid=1072866584906656040-EU)

5 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Johann Burgstaller shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • burgstjo commented  ·   ·  Report

    I tried the following and it worked as expected - great job!!! :-)

    =byrow(B15:C,lambda(x,index(x,1,1)+index(x,1,2)))
    =bycol(B15:C17, lambda(x, sum(x)))
    =map(H12:N12, lambda(x, x*2))
    =reduce(0, H12:N12, lambda(accumulator, current_value, accumulator+current_value))

    But it seems, this functionality is not officially released. At least it is not available in the list of functions in Proton Sheets. Could you please fix this?

  • Chell commented  ·   ·  Report

    Just going to add REDUCE and SCAN LAMBDA functions as well :)

  • Joram commented  ·   ·  Report

    And the same goes for the BYCOL and MAP lambda functions. These three are unmissable to my workflow.

Proton Drive: New feature

Categories