Welcome to SheetRocks Documentation

SheetRocks is a powerful spreadsheet application that brings familiar spreadsheet functionality to modern platforms. Whether you're working with enterprise data, building complex workflows, or managing business processes, SheetRocks provides the tools you need.

Quick Links

Getting Started

• Getting Started Guide - Learn the basics of using SheetRocks
• Basic Features - Explore core spreadsheet features
• Advanced Features - Master advanced capabilities

Reference

• Formula Reference - Complete guide to 150+ functions
• Recipes - Practical patterns and examples

Platform Guides

• Solution Overview - Learn about SheetRocks architecture and benefits
• Salesforce Integration - Salesforce-specific setup and features

What is SheetRocks?

SheetRocks combines the familiar spreadsheet interface with the power of modern cloud platforms. It provides:

• 150+ Spreadsheet Functions - Complete compatibility with Excel-style formulas
• Advanced Features - Lambda functions, dynamic arrays, and powerful data transformations
• Real-time Collaboration - Work together on spreadsheets with your team
• Platform Integration - Deep integration with Salesforce and other platforms
• Enterprise Security - All data stays within your platform boundaries

Key Features

Comprehensive Spreadsheet Functions

Access a full suite of functions including math, statistical, financial, text manipulation, date/time operations, and more. All functions include detailed documentation with examples.

Advanced Formula Capabilities

• COL Syntax - Reference entire columns for dynamic operations
• Lambda Functions - Filter and transform data with powerful expressions
• ONCE and ONCHANGE - Control formula recalculation for timestamps and expensive operations
• TAGS Function - Convert tables to interactive JSON objects

Linked Sheets

Connect your spreadsheets to external data sources with bidirectional syncing. Linked sheets provide on-demand data updates and seamless integration.

Templates and Workflows

Create reusable templates to standardize processes across your organization. Templates canonicalize workflows and ensure consistency.

Popular Formulas

Here are some of the most commonly used formulas in SheetRocks:

• SUM - Add numbers together
• AVERAGE - Calculate the average of numbers
• IF - Conditional logic
• VLOOKUP - Look up values in a table
• FILTER - Filter data based on conditions
• MAP - Transform arrays with lambda functions

Browse all formulas →

Need Help?

• Email Support: [email protected]
• Try the App: Launch SheetRocks

Getting Started

Ready to start using SheetRocks? Head over to the Getting Started Guide to learn the basics.