# sheet.rocks

> AI-optimized mirror of sheet.rocks containing 50 pages totalling 23,348 words of clean markdown content, structured data, and semantic HTML. Original source: https://sheet.rocks/. Last updated: 2026-04-26T18:45:10.310Z.

Each page is available as HTML (with JSON-LD structured data) and Markdown (text-only, ideal for LLMs and RAG).

## Homepage

- [The Spreadsheet for Everywhere](/site-root.html): SheetRocks gives every platform a powerful, familiar spreadsheet engine—built directly into the tools teams already use. (911 words)

## Articles & Blog Posts

- [ISBETWEEN](/docs/formulas/isbetween-html.html): Returns true if a provided number is between two other numbers either inclusively or exclusively; otherwise returns false. (400 words)
- [salesforce/templates/index.html](/salesforce/templates/index.html) (1 words)
- [TAKE](/docs/formulas/take-html.html): Returns the first N rows and optionally first N columns from an array. Returns an error if the result would be empty. (526 words)
- [SEQUENCE](/docs/formulas/sequence-html.html): Returns the list of generated sequential numbers in an array. (495 words)
- [TRANSPOSE](/docs/formulas/transpose-html.html): Returns the result after transposing the rows and columns of an array or range. (479 words)
- [IFS](/docs/formulas/ifs-html.html): Returns the value corresponding to the first TRUE result when evaluating multiple tests. (390 words)
- [VSTACK](/docs/formulas/vstack-html.html): Vertically stacks arrays by appending rows (502 words)
- [SORTBY](/docs/formulas/sortby-html.html): Sorts a range or array based on values in one or more corresponding ranges or arrays. (539 words)
- [UNIQUE](/docs/formulas/unique-html.html): Returns a list of unique values in a list or range. (517 words)
- [HLOOKUP](/docs/formulas/hlookup-html.html): Returns the corresponding value from the specified row of table which matches exactly or approximately to the first row of the table. (534 words)
- [HSTACK](/docs/formulas/hstack-html.html): Horizontally stacks arrays by appending columns (490 words)
- [GROUPBY](/docs/formulas/groupby-html.html): Groups data by a key and applies an aggregator function to each group (526 words)
- [MATCH](/docs/formulas/match-html.html): Returns the position of the item/lookup_value in the lookup_array or range. (573 words)
- [LAST](/docs/formulas/last-html.html): Returns the last N rows and optionally last N columns from an array. Returns an error if the result would be empty. (528 words)
- [DROP](/docs/formulas/drop-html.html): Drops the first N rows and optionally first N columns from an array. Returns an error if the result would be empty. (525 words)
- [SORT](/docs/formulas/sort-html.html): Sorts the values in a range or array. (502 words)
- [CHOOSE](/docs/formulas/choose-html.html): Uses index to return a value from the list of value arguments (471 words)
- [docs/formulas/index.html](/docs/formulas/index.html) (1 words)
- [ROW](/docs/formulas/row-html.html): Returns the 1-indexed row number of the current cell (418 words)
- [COLUMN](/docs/formulas/column-html.html): Returns the column number of the current cell context. (401 words)
- [SheetRocks for Salesforce](/docs/salesforce-html.html) (1,174 words)
- [IFERROR](/docs/formulas/iferror-html.html): Returns a custom result when a formula generates an error, and a normal result when no error is detected. (359 words)
- [AND](/docs/formulas/and-html.html): Returns true if all arguments evaluate to true (342 words)
- [SheetRocks Solution Overview](/docs/overview-html.html) (889 words)
- [CONTAINS](/docs/formulas/contains-html.html): Returns true if a range contains a specified value (337 words)
- [VLOOKUP](/docs/formulas/vlookup-html.html): Returns a value from a table by looking up a value in the first column and returning a value from the specified column (594 words)
- [salesforce/demo/index.html](/salesforce/demo/index.html) (1 words)
- [SUM](/docs/formulas/sum-html.html): Returns the sum of all numbers in the provided arguments (399 words)
- [FILTER](/docs/formulas/filter-html.html): Returns a filtered array containing only rows that match the criteria (521 words)
- [AVERAGE](/docs/formulas/average-html.html): Returns the average of given arguments. Text is ignored. (406 words)
- [IF](/docs/formulas/if-html.html): Returns the first value if logical_expression is TRUE; otherwise returns the second value. (367 words)
- [MAP](/docs/formulas/map-html.html): Processes each row in an array with a formula including a COL or CELL keyword and returns it as a 2D array. (487 words)
- [Basic Features](/docs/basic-features-html.html): Explore core SheetRocks features (389 words)
- [The Spreadsheet for Salesforce](/salesforce/index.html): A powerful, familiar spreadsheet engine built natively for Salesforce. Streamlined data entry, bulk editing, and analytics without leaving your org. (696 words)
- [The Spreadsheet for Shopify](/shopify/index.html): SheetRocks for Shopify is a powerful, familiar spreadsheet engine built directly for your Shopify store. Streamlined bulk editing and analytics. (877 words)
- [formulas/index.html](/formulas/index.html) (1 words)
- [Advanced Features](/docs/advanced-features-html.html): Master advanced SheetRocks capabilities (373 words)
- [SheetRocks Recipes](/docs/recipes-html.html): Practical patterns and examples for SheetRocks (1,304 words)
- [The Spreadsheet for WooCommerce](/woocommerce/index.html): A powerful, familiar spreadsheet engine built natively for WooCommerce. Streamlined bulk editing, analytics, and product management. (838 words)
- [The Spreadsheet for HubSpot](/hubspot/index.html): A powerful, familiar spreadsheet engine built natively for HubSpot. Streamlined data entry, bulk editing, and analytics without leaving your CRM. (889 words)
- [The Spreadsheet for ServiceNow](/servicenow/index.html): A powerful, familiar spreadsheet engine built natively for ServiceNow. Streamlined data entry, bulk operations, and analytics directly in your instance. (706 words)
- [The Spreadsheet for Gravity Forms](/gravity/index.html): A powerful, familiar spreadsheet engine built natively for Gravity Forms. Streamlined entry management, bulk editing, and analytics. (851 words)
- [Getting Started](/docs/getting-started-html.html): Learn the basics of using SheetRocks (141 words)
- [Welcome to SheetRocks Documentation](/docs/index.html) (378 words)
- [Workbook 1](/sandbox/index.html): SheetRocks - Native Spreadsheet for the Web (17 words)
- [DEC2BIN](/formulas/dec2bin/index.html) (80 words)
- [DEC2OCT](/formulas/dec2oct/index.html) (80 words)
- [Free Forever](/login/index.html) (45 words)
- [DEC2HEX](/formulas/dec2hex/index.html) (78 words)

## Resources

- [Full Page Index](/index.html): Browse all cached pages with rich metadata
- [About This Cache](/content/about.html): Methodology, technical details, and usage guidelines
- [XML Sitemap](/content/sitemap.xml): Machine-readable sitemap for crawler discovery
- [Robots.txt](/content/robots.txt): Crawler directives