606 questions
0
votes
2
answers
61
views
passing a date object to a google app script function
This seems weird.
I have a cell a1: containing [Jan 1, 1984].
I have a function xxx
function xxx(d) {
return d;
}
if I try this in a cell like
=xxx(a1)
that returns 1
no matter what the year is.
if ...
- 2,907
-1
votes
0
answers
31
views
Apps Script custom function result in Google Sheets being cached for cells where it has already been evaluated [duplicate]
Google Apps Script/Google Sheets issue...
The custom function in code.gs:
function SHEETNAME() {
return SpreadsheetApp.getActiveSheet().getName();
}
Then in Sheet1 cell A1 put:
=SHEETNAME()
A1 ...
- 1,131
-1
votes
3
answers
190
views
Google Sheets Custom Function Receiving Literal Values Instead of Range Objects (Persistent Issue) [duplicate]
I'm experiencing an issue with a Google Apps Script custom function in my Google Sheet. My custom function (designed to sum cells by background color) is consistently receiving literal cell values (e....
0
votes
1
answer
74
views
Google Sheets Add On Executing custom functions when sheet is shared
I have built and published a Google Sheets Add-on.
The Official Similarweb For Google Sheets��
The custom functions in the Add-on refer to an API key that is stored in user properties and then call the ...
0
votes
0
answers
27
views
google sheets app script use selection as input (e.g. C105:I105) [duplicate]
I want to call a custom function like this in Google Sheets:
=countColoredCells(C105:I105, "#ff0000")
Where C105:I105 is a range reference, the same way you would use it in =SUM(C105:I105). ...
- 385
0
votes
0
answers
16
views
How to create a safe custom function in OceanBase that returns consistent results?
I'm trying to create a simple custom function in OceanBase (Community Version 4.2, MySQL mode) that calculates a discount price, but it returns inconsistent results when called multiple times in the ...
user30403414
1
vote
1
answer
334
views
Error "function is empty or cannot be parsed" while saving custom function in FlutterFlow
I have a custom function in my FlutterFlow app with this code:
import 'dart:convert';
import 'dart:math' as math;
import 'package:flutter/material.dart';
import 'package:google_fonts/google_fonts....
- 21
2
votes
1
answer
86
views
Throwing errors in an array-valued custom formula [duplicate]
I have created a custom formula in Google Sheets that can take in an array and output another array. Some of the values in the input array may result in an error; I would like to show that error for ...
- 107
-3
votes
1
answer
193
views
Spreadsheet custom function suddenly stop working
I use this to keep track of my stock portfolio, been using it for almost three years now, and recently it stop working, can't figure out why.
function MyPortfolio2(tickers, values , price)
{
var ...
- 9
2
votes
3
answers
96
views
Create an R function which dynamically and sequentially applies other predefined functions to an initial input variable
I have a very simple set of functions which take an input character variable (a word or phrase) and return a new one. Basically,
each of these functions performs a different encryption on the input ...
- 492
0
votes
1
answer
65
views
How to make a function format data within its own cell?
I want a custom function that can auto format data units. Turning 1000 m to 1 km. Put simply I cannot get the function to format the cell it is located in.
I plan on adding conditions later to format ...
- 9
1
vote
2
answers
241
views
Excel Custom Function returning a Range
Please forgive if the question has been asked before but I'm new to Excel VBA and stackoverflow.
I'm trying to write a custom function to merge two cells together maintaining the original formatting ...
- 13
0
votes
2
answers
96
views
How to get Sales order , Quotation , Invoice details in custom function for customers module?
I am pretty new to zoho books. Here, I am trying to create a custom function in zoho books. Right now, I just want to know whether a particular customer has invoice or quotation or sales order.
...
-1
votes
1
answer
67
views
Avoid re-rendering of a custom function
I am defining a custom function in Google Apps Script that calls an external API to return some value in the cell. It seems like that it keeps calling this function at certain intervals or on opening ...
1
vote
2
answers
78
views
What elements of this section of code do I need to adjust once I duplicate it to add another variable?
I was given a custom function to add to the spreadsheet I’m building but it doesn’t quite do what I now need it to do. I have a basic understanding of JavaScript but since I didn’t write this code, I’...
- 11