Custom Functions and Recalculation

by

The proper way to make that a custom function to recalculate is to change a parameter of it. Regarding the use of NOW() and other similar built-in functions as paremeters of custom functions, from Custom functions in Google Sheets

Custom function arguments must be deterministic. That is, built-in
spreadsheet functions that return a different result each time they
calculate — such as NOW() or RAND() — are not allowed as arguments to
a custom function. If a custom function tries to return a value based
on one of these volatile built-in function, it will display Loading…
indefinitely.

From a comment by Mogsdad to this answer:

In fact, rather than “Loading…”, this will display an #ERROR!, This function is not allowed to reference a cell with NOW(), RAND(), or RANDBETWEEN()

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. Custom functions intermittently hang with “Error – Loading Data”
  3. Selecting the last value of a column
  4. Custom function throws a “You do not have the permission required to setValue” error
  5. Refresh data retrieved by a custom function in Google Sheet
  6. How to evaluate a spreadsheet formula within a custom function?
  7. Passing cell references to spreadsheet functions
  8. Moving google apps script to v8 file upload stopped working from sidebar
  9. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  10. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  11. No permission to call msgBox in Google Apps Scripting
  12. How to define global variable in Google Apps Script
  13. Periodically refresh IMPORTXML() spreadsheet function
  14. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  15. Format a Google Sheets cell in plaintext via Apps Script
  16. UiApp has been deprecated. Please use HtmlService instead
  17. Google app scripts: email a spreadsheet as excel
  18. Is there a way to keep two sheets synchronized?
  19. Google apps script to email google spreadsheet excel version [duplicate]
  20. How to get filtered values from Filter after using setColumnFilterCriteria?
  21. GAS “On edit” trigger not running when edited from API
  22. Difference between getValue() and getDisplayValue() on google app script
  23. How to allow onEdit function to affect protected cell in a Google Sheet?
  24. Measurement of execution time of built-in functions for Spreadsheet
  25. Custom Functions with add-ons?
  26. How to prefill Google form checkboxes?
  27. Iterate over range, append string to each
  28. Can the google spreadsheet ‘query’ function be used in google apps script?
  29. How to pause App Scripts until spreadsheet finishes calculation
  30. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?

Leave a Comment