594 questions
1
vote
1
answer
36
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....
- 11
2
votes
1
answer
62
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 ...
- 105
-3
votes
1
answer
147
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
87
views
Create an R function which dinamycally 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 ...
- 413
0
votes
1
answer
54
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
164
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
45
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
49
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 ...
0
votes
0
answers
94
views
Check updated items older than x
I want to make a filter for my colleagues showing Jira items which have not been updated for x-amount of days, but only working days.
The specifc amount of days will be static, but so far I not sure ...
- 3
2
votes
2
answers
71
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’...
- 21
0
votes
3
answers
125
views
How to get a list of all sheet names that contain "week of" that updates on edit
Im new to Apps Script and need some assistance with the code required to get a list of all sheet names (current and those to be created) that will start with "Week of" in the title. Ideally ...
0
votes
1
answer
65
views
Trying to reduce Column A by 10% and then replace the old numbers in Column A with the new numbers
So I have almost zero knowledge of custom functions in Google Sheets. But I am trying to take the numbers in each cell in Column A, reduce it by 10%, then replace the old numbers with the new reduced ...
0
votes
0
answers
80
views
Substantial difference between GOOGLEFINANCE on sheets and on-platform
I'm using GOOGLEFINANCE to plot SPARKLINE miniatures of forex currencies. I use these miniatures as a preview, looking for any interesting patterns, so that I can inspect details on Google Finance ...
- 6,068
0
votes
0
answers
53
views
Update cells with custom formula upon any part of workbook being edited [duplicate]
I have a custom formula where I check the workbook for a certain cell color and return the sum. I also want to update the cell for the last date and time the function was run/updated. I currently have ...
0
votes
0
answers
59
views
Run script and update same cell when changes to spreadsheet are made [duplicate]
I'm trying to update the cell when changes are made on any sheet in the workbook. Here is the script that only runs when I initially call the function in the cell
function countColoredCells(countRange,...