LAMBDA

Creates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares. Learn more

Video field
Logical

In Google Sheets, LAMBDA is a function that allows users to create their own custom functions using a combination of parameters and a formula expression.

The LAMBDA function takes two arguments: the name of the custom function you want to create and the formula expression that defines the function. The formula expression should reference one or more of the parameters you define within the LAMBDA function.

Once you create a custom function with LAMBDA, you can use it in the same way you would use any other function in Google Sheets, by typing its name followed by the required parameters.

This feature is particularly useful for tasks that require more complex or specialized calculations that are not available through built-in Google Sheets functions.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!