Can someone help me figure out how Google Sheets' inbuilt Lambda function works? There is no official documentation for it and the only information available is as in the below snapshot.
When using the lambda function as per the Help Box, Google Sheets is showing error as below.
You can't use it. The Google Sheets source code does seem to have a (perhaps partial?) implementation of LAMBDA, but there is no way to use it. It appears Google started working on implementing Excel's LAMBDA in Google Sheets, but accidentally gave it documentation before it was complete, resulting in it being documented, but unusable. Presumably it is enabled for Google Sheets developers only right now.
Google officialy released today the lambda function, along with other functional programming related features. Here is the official doc page.
Google officially released the lambda function and its helper functions, but not all users were supported at the time you posted your question, so the error message indicates that it is an unknown function.
See support.google for the LAMBDA function.
