UTILITIES

Description

We've added all kinds of utility functions that can retrieve spreadsheet info, like:

• remaining cells in sheet
  • UTIL_CELLSREMAININGSHEET()
• remaining cells in spreadsheet
  • UTIL_CELLSREMAININGSPREADSHEET()
• cells remaining to spreadsheet limit of 2 million
  • UTIL_CELLSTOSPREADSHEETLIMIT()
• spreadsheet name
  • UTIL_SPREADSHEETNAME()
• sheet name
  • UTIL_SHEETNAME()
• total number of sheets
  • UTIL_TOTALSHEETS()
• sheet index
  • UTIL_SHEETINDEX()
• reverse text
  • UTIL_REVERSETEXT(textrange)
• count number of formulas used in either range or sheet
  • UTIL_COUNTFORMULAS(A1notation)
• retrieve a value fro all sheets
  • UTIL_UTIL_VALUESHEETS(A1notation)
• get the locale of a sheet
  • UTIL_GETLOCALE()
• get the timezone the speadsheet is in
  • UTIL_GETTIMEZONE()
• get the URL of the spreadsheet you're working in
  • UTIL_GETURL()
• get the Id of the spreadsheet
  • UTIL_GETID()

If you want to have more utilities added, please use the Google Forms on our website.