Array constants can only contain text in double quotes, plain numbers (no currency symbols or percent signs), or Boolean ...

Google has announced that Google Sheets is getting the ability to intelligently suggest formulas and functions for your spreadsheet, based on the data you’re trying to analyze. For example, typing “=” ...