Using built-in spreadsheet functions in a script

by

Google Apps Script is a subset of JavaScript, spreadsheet functions are currently not supported.
For example, if you want to create a function that returns today’s date you should write :

function test_today(){
return new Date()
}// note that this will  eventually return a value in milliseconds , you'll have to set the cell format to 'date' or 'time' or both ;-)

syntax is the same as with sheet functions : =test_today() see tutorial

There are many internet ressources on javascript, one of the most useful I found is w3school

More Related Contents:

  1. Is there a way to evaluate a formula that is stored in a cell?
  2. No permission to call msgBox in Google Apps Scripting
  3. Apps Script: how to get hyperlink from a cell where there is no formula
  4. Periodically refresh IMPORTXML() spreadsheet function
  5. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  6. Selecting the last value of a column
  7. Google Sheet use Importxml error could not fetch url [duplicate]
  8. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  9. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  10. Determining the last row in a single column
  11. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  12. Google Sheets OnEdit() – You do not have permission to call a service
  13. Detect user inserting row or column in a google spreadsheet and reacting in a script
  14. Get the last non-empty cell in a column in Google Sheets
  15. How to get onFormSubmit to trigger automatically?
  16. Copying a spreadsheet copies all linked files as well
  17. onEdit simple trigger never seems to be triggered
  18. “SpreadsheetApp.getUi() cannot be called from this context”
  19. How to get filtered values from Filter after using setColumnFilterCriteria?
  20. Protect ranges with google apps script
  21. How to access new ‘in-cell-image’ from google apps script?
  22. How to convert a Google Sheets-File to an Excel-File (XLSX)
  23. How to allow onEdit function to affect protected cell in a Google Sheet?
  24. Creating and Sending sheets in the same function
  25. How do I know if spreadsheet cells are merged using google apps script
  26. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  27. Google apps script error: “You do not have permission to call protect” [duplicate]
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. Is it possible to create macro buttons to navigate in Google Sheets?
  30. Publish an add-on privately

Leave a Comment