Google Sheets MAP Function: A LAMBDA Helper Function
Use the MAP Function in Google Sheets to create outputs from one or more arrays in conjunction with the LAMBDA function. In this video, we jump into an example using Salesforce data to understand the amount of opportunities by stage. We'll compare with the SUMIFS function.
Video Timeline
00:00: Google Sheets New MAP Function
00:23: Opportunities by Stage SUMIFS Example
01:28: MAP Function Example
02:07: Create Your LAMBDA Function
02:28: Naming in the LAMBDA Function
03:15: Combine Two Arrays to Create a New Array
04:24: Combine First and Last Name with MAP Function
► Come see us: https://www.coefficient.io/?utm_mediu...
Any questions? Comment below; we have Google Sheets experts on the other side.
#googlesheets #mapfunction #coefficient