Stack Overflow
Stack Overflow

Questions tagged [named-function]

Use for functions that are named. Use with [google-sheets] for questions related to the named functions feature.

In spreadsheet software like , Named functions just like named ranges refer to functions that are custom built using inbuilt formulas. This is not to be confused with , which refer to functions built with

References:

12 questions
4
votes
2 answers

Can I make a named function in google sheets that will reference a cell in the sheet it is used in

I am making a named function that needs to reference a cell in the sheet and whenever I make it and type for instance $D$4 it converts it to 'SheetName'!$D$4(First sheet's D4) making it to where I can't use the named function in other sheets. Is…
Red Reaper
  • 51
  • 3
4
votes
1 answer

Give the named function argument a default value if not specified

I created a formula to sort positive values. =SORT(FILTER(A2:A, A2:A>0),1,1) And turnd it to a named function with this formula definition, and named it SORT_POSITIVE =SORT(FILTER(range, range>0),sort_column,is_ascending) To use it like…
Osm
  • 2,699
  • 2
  • 4
  • 26
4
votes
3 answers

What factors determine the memory used in lambda functions?

=SUM(SEQUENCE(10000000)) The formula above is able to sum upto 10 million virtual array elements. We know that 10 million is the limit according to this question and answer. Now, if the same is implemented as Lambda using Lambda helper function…
TheMaster
  • 45,448
  • 6
  • 62
  • 85
2
votes
1 answer

Importing named functions

Google Sheets has a new feature rolled out earlier called named functions and it is pretty useful. However, you need to manually import it into your sheet. I didn't see anything in the docs on how to do it programmatically. Do anybody know how to do…
jason
  • 3,811
  • 18
  • 92
  • 147
1
vote
2 answers

How does recursion work in google sheets defined functions?

Here is an example given by google of a Named function using recursion =IF(ISERROR(FIND(" ", str)), str, REVERSE_WORDS(RIGHT(str, LEN(str)-FIND(" ", str)))&" "&LEFT(str, FIND(" ",str)-1)) This function will take "1 2 3 4" and the final output will…
CodeCamper
  • 6,609
  • 6
  • 44
  • 94
0
votes
3 answers

How can I sum a named function over a given range of values?

I'm making a financial analysis model for real estate properties. I created a named function called INCOME that calculates total income for a given property name from a database of different income types for each property, e.g. rent, late fees,…
Kim Hopkins
  • 59
  • 7
0
votes
4 answers

Formula to return relative position of nth non-zero value breaks for n > 2?

I have been trying to put together a named function in Google Sheets that will output the relative position of a cell within a single row that contains the nth non-zero value. Day1 Day2 Day3 Day4 Day5 Day6 Day7 1st Non-0 2nd Non-0 3rd…
aboyd
  • 3
  • 3
0
votes
1 answer

Return relative position of Nth non-zero value in a range

I have been trying to come up with a way to return the relative position of the nth non-zero value in a row range within Google Sheets. I have asked this question on Reddit too…
aboyd
  • 3
  • 3
0
votes
1 answer

Modify an existing named function that returns a Cartesian product / cross join by adding an argument that specifies the # of columns/values per row

I found the following Google Sheets named function CARTESIAN_PRODUCT as an answer to a related question Here: =IF(COLUMNS(range) = 1, IFNA(FILTER(range, range <> "")), LAMBDA(sub_product, last_col, REDUCE(, SEQUENCE(ROWS(sub_product)), LAMBDA(acc,…
Iceman6425
  • 1
  • 1
0
votes
1 answer

Specify condition within preset comparison operator?

I am experimenting with Named Functions in Google Sheets and trying to make a function to take start and end date arguments to look between within a custom formula. I cannot figure out how to put the dates in a preset comparison and work properly.…
Dylan Livingston
  • 1
0
votes
1 answer

GS Named Function Not Accepting Named Function Output as Input

Introduction I'm trying to create custom Google Sheets functions for tabletop rolls and rules, and I ran into what appears to be a technical limitation on part of Google Sheets new Named Functions feature, but I'm hoping to be wrong and hope the…
Bombasticus
  • 1
  • 3
-1
votes
1 answer

Google Sheets Named Functions - cell references are absolute?

I thought I was onto an excellent way to re-use cell formulas - but came up against the named function editor being determined to mangle anything I entered into absolute cell references - so I couldn't drag cells containing my named formula and have…
badcop666
  • 121
  • 2
  • 9