Named Functions, LAMBDA, MAP, REDUCE and More - New Google Sheets Functions

Ғылым және технология

‪@yagisanatode‬ comes on the channel today to show us how to use a new batch of advanced functions in Google Sheets.
Scott's Related Videos:
Calculate the duration between two times in a day in Google Sheets as a number:
• Calculate the duration...
Create a Dynamic Password Generator in Google Sheets
• Create a Dynamic Passw...
Scott's website: yagisanatode.com/
Timestamps:
0:00 Intro
2:34 Named Function (Adam's version)
8:04 LAMBDA Function
8:54 LAMBDA Helper Functions
14:37 MAP Function
19:16 Named Functions (Scott's version)
23:48 REDUCE Function
30:11 SCAN Function
33:16 Random String Generator
33:39 Named Functions Pack
#googlesheets #spreadsheet #workspace

Пікірлер: 5

  • @BraveHeart-ht8zf
    @BraveHeart-ht8zf Жыл бұрын

    I love this tutorial

  • @user-de2fq2hl7b
    @user-de2fq2hl7b8 ай бұрын

    This is quite good, I've done some functional programming before, but translating that to Sheets has somehow not clicked until now. Thanks!

  • @ProlificOaktree

    @ProlificOaktree

    7 ай бұрын

    Best of luck. Let us know how it goes.

Келесі