{"_id":"55c386b0b6e05719008a0544","version":{"_id":"55a7aee84a33f92b00b7a153","__v":6,"project":"55a7aee84a33f92b00b7a150","createdAt":"2015-07-16T13:17:28.411Z","releaseDate":"2015-07-16T13:17:28.411Z","categories":["55a7aee94a33f92b00b7a154","55a7fefa3efe0c2f0074cbdf","55a8fb10c8bd450d000dd130","55a936b1cf45e1390093f362","55abddeaa36ccd0d00fdebe1","5624db675a86b423009462e1"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"project":"55a7aee84a33f92b00b7a150","__v":11,"category":{"_id":"55a7fefa3efe0c2f0074cbdf","pages":["55a7ff621fa1a53b006915e6","55a8086a8b9fdf0d00117087","55c3409857f7f32d0016ebf4","55c37a438713ec1900d17467","55c385e357f7f32d0016ed2a","55c386b0b6e05719008a0544","55c38a07b6e05719008a0554"],"project":"55a7aee84a33f92b00b7a150","version":"55a7aee84a33f92b00b7a153","__v":7,"sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-07-16T18:59:06.950Z","from_sync":false,"order":4,"slug":"google-sheets-add-on","title":"Google Sheets Add-on"},"parentDoc":null,"user":"55a7ae50bf1be93100d89df1","updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-08-06T16:09:20.825Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":5,"body":"The Text Analysis add-on comes with a set of formulas for performing Text Analysis operations with more flexibility, just like how you use the `=SUM` function or [any other formula](https://support.google.com/docs/table/25273?hl=en) in Excel or Google Spreadsheets.\n\nJust enter an equal sign `=` in a cell and start typing a formula from the below list to get suggestions:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/H1In0JUETMa553p5eiek_Formulas.png\",\n        \"Formulas.png\",\n        \"667\",\n        \"335\",\n        \"#3b4e72\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:callout]\n{\n  \"type\": \"warning\",\n  \"title\": \"Formulas and recalculation\",\n  \"body\": \"Results obtained via formulas may get recalculated if you reopen a sheet after 6 hours from the original analysis.\"\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Formula list\"\n}\n[/block]\n  * **=Classification(value):** Returns the classification of a text or URL.\n  * **=Hashtags(value):** Returns a list of suggested hashtags for a text or URL.\n  * **=Language(value):** Returns the main language of a text or URL in ISO 639-1 format.\n  * **=Concepts(value):** Returns a list of concepts mentioned in a text or URL.\n  * **=SentimentPolarity(value):** Returns the polarity (‘positive’ or ‘negative’) of a text or URL.\n  * **=SentimentSubjectivity(value):** Returns the subjectivity (‘subjective’ or ‘objective’) of a text or URL.\n  * **=People(value):** Returns a list of the people mentioned in a text or URL.\n  * **=Organizations(value):** Returns a list of the organizations mentioned in a text or URL.\n  * **=Locations(value):** Returns a list of the locations mentioned in a text or URL.\n  * **=Keywords(value):** Returns a list of keywords from a text or URL.\n  * **=Dates(value):** Returns a list of all date values mentioned in a text or URL.\n  * **=Money(value):** Returns a list of all money values mentioned in a text or URL.\n  * **=Percentages(value):** Returns a list of all percentage values mentioned in a text or URL.\n  * **=Times(value):** Returns a list of all time values mentioned in a text or URL.\n  * **=URLs(value):** Returns a list of all links mentioned in a text or URL.\n  * **=Emails(value):** Returns a list of all email addresses mentioned in a text or URL.\n  * **=Phones(value):** Returns a list of all phone numbers mentioned in a text or URL.\n  * **=Summarize(value,[title]):** Returns a list of key sentences from a text or URL.\n  * **=PageTitle(url):** Returns the title of an URL.\n  * **=PageText(url):** Returns the text of an URL.\n  * **=MainImage(url):** Returns the main image of an URL.\n  * **=Videos(url):** Returns the embedded videos of an URL.\n  * **=Author(url):** Returns the author name of an URL.\n\n<a class=\"btn btn-success\" style=\"color: #fff;\" href=\"https://s3.amazonaws.com/aylien-main/resources/text-analysis-addon/FunctionCheatSheet.pdf\"><i class=\"fa fa-download\"></i> Download in PDF format</a>","excerpt":"","slug":"formulas","type":"basic","title":"Formulas"}
The Text Analysis add-on comes with a set of formulas for performing Text Analysis operations with more flexibility, just like how you use the `=SUM` function or [any other formula](https://support.google.com/docs/table/25273?hl=en) in Excel or Google Spreadsheets. Just enter an equal sign `=` in a cell and start typing a formula from the below list to get suggestions: [block:image] { "images": [ { "image": [ "https://files.readme.io/H1In0JUETMa553p5eiek_Formulas.png", "Formulas.png", "667", "335", "#3b4e72", "" ] } ] } [/block] [block:callout] { "type": "warning", "title": "Formulas and recalculation", "body": "Results obtained via formulas may get recalculated if you reopen a sheet after 6 hours from the original analysis." } [/block] [block:api-header] { "type": "basic", "title": "Formula list" } [/block] * **=Classification(value):** Returns the classification of a text or URL. * **=Hashtags(value):** Returns a list of suggested hashtags for a text or URL. * **=Language(value):** Returns the main language of a text or URL in ISO 639-1 format. * **=Concepts(value):** Returns a list of concepts mentioned in a text or URL. * **=SentimentPolarity(value):** Returns the polarity (‘positive’ or ‘negative’) of a text or URL. * **=SentimentSubjectivity(value):** Returns the subjectivity (‘subjective’ or ‘objective’) of a text or URL. * **=People(value):** Returns a list of the people mentioned in a text or URL. * **=Organizations(value):** Returns a list of the organizations mentioned in a text or URL. * **=Locations(value):** Returns a list of the locations mentioned in a text or URL. * **=Keywords(value):** Returns a list of keywords from a text or URL. * **=Dates(value):** Returns a list of all date values mentioned in a text or URL. * **=Money(value):** Returns a list of all money values mentioned in a text or URL. * **=Percentages(value):** Returns a list of all percentage values mentioned in a text or URL. * **=Times(value):** Returns a list of all time values mentioned in a text or URL. * **=URLs(value):** Returns a list of all links mentioned in a text or URL. * **=Emails(value):** Returns a list of all email addresses mentioned in a text or URL. * **=Phones(value):** Returns a list of all phone numbers mentioned in a text or URL. * **=Summarize(value,[title]):** Returns a list of key sentences from a text or URL. * **=PageTitle(url):** Returns the title of an URL. * **=PageText(url):** Returns the text of an URL. * **=MainImage(url):** Returns the main image of an URL. * **=Videos(url):** Returns the embedded videos of an URL. * **=Author(url):** Returns the author name of an URL. <a class="btn btn-success" style="color: #fff;" href="https://s3.amazonaws.com/aylien-main/resources/text-analysis-addon/FunctionCheatSheet.pdf"><i class="fa fa-download"></i> Download in PDF format</a>