Does SmartSheet have an equivalent to Excel's "Name Manager" and "LAMBDA"?

MHumphrey

I need a way to label a specific set of data or create a custom function that can be used in cross-worksheet formulas.

Related to another query of mine, I need to take a list, give it a specific name, and reference it without having to navigate to the source sheet every time it's needed.

For example, let's say I have a list of 200 names that's located in a workspace 8 folders deep (hypothetical but bear with me). I want to label that 200-name list as "Names" and use "Names" in calculations without having to "reference another sheet."

Using linked columns does not work in this case.

Additionally, I need the ability to use 'Name Manager' to create "custom functions" like Excel's LAMBDA. For those not familiar, you can "name" a LAMBDA function, simple or complex, and use it as a function wherever needed.

For example, let's say that I have a nested COUNTIFS function with 12 conditions that I use in a variety of worksheets for a variety of applications. Instead of having to rewrite the formula in each calculation sheet (and fix the reference sheets EVERY TIME), I could use '=NAMED_FUNCTION()' and rock'n'roll.

Is this feature available?

Melissa Yamada

No — Smartsheet does not support named ranges, named lists, or custom / reusable functions like Excel’s Name Manager or LAMBDA.

There is no way to:

Assign a name to a range (for example “Names”) and reuse it across sheets

Reference a list without explicitly creating a cross-sheet reference

Every cross-sheet formula in Smartsheet must:

Point to a specific sheet

Define the exact column or range

Be recreated per sheet (references are not portable)

What people do instead (the closest supported patterns):

Maintain a single “lookup / config” sheet and reference it everywhere (yes, references must be rebuilt per sheet)

Use column formulas to reduce copy/paste inside a sheet

Use Data Shuttle to distribute static lists

Use Bridge or the API for true reusable logic outside formulas