Calling a google sheets custom function from another custom function

Question

I am trying the following in a Google Sheet which produces an error because although function_2() correctly returns an object when I test it in the editor (or when I set it to return JSON.stringify and call it in the spreadsheet directly which displays correct JSON), that object is somehow converted to an empty string when it should be passed to function_1() as a parameter:

=function_1(B2,B3,function_2(A1,A2))

Any ideas?

Wicket · Accepted Answer · 2018-01-08 19:49:53Z

1

Custom functions should return a single value or an array of values in order to work in a Google Sheets formulas.

The value or values should be valid Google Sheets values, in other words, number, text, boolean or date.

JavaScript objects types that are converted to valid Google Sheets are

Number to number. Percentage, currency and other number formats depend on Google Sheets formatting.
String to text.
Date to date.
- Note: Conversion to time, date-time or duration depends on cell formatting but duration could be complicated
Boolean to boolean.

Reference

Custom functions in Google Sheets

edited Jan 8, 2018 at 19:49

answered Jan 8, 2018 at 19:41

Wicket

39.4k9 gold badges81 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user531065 Over a year ago

Got it so since I'm returning a valid JS object but not a valid GS object it's not working. Thanks!

Collectives™ on Stack Overflow

Calling a google sheets custom function from another custom function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related